How to Display Primary and Foreign Key Constraints for Specific Tables in MySQL?

Examining Table Constraints

Constraining tables with primary (PK) and foreign keys (FK) is essential for maintaining data integrity. To validate these constraints, MySQL provides a valuable command.

Question:

How can you display the PK/FK constraints for specific tables?

Answer:

To view the constraints for a given table, use the following command:

SHOW CREATE TABLE <table_name>;

Example:

To examine the constraints for the practices and cred_insurances tables in the credentialing1 database:

SHOW CREATE TABLE credentialing1.practices;
SHOW CREATE TABLE credentialing1.cred_insurances;

The output of this command will provide a comprehensive SQL statement that re-creates the table as it currently exists. This statement includes details on:

• Table name
• Column definitions (types, sizes, constraints)
• Primary key and foreign key constraints
• Table type, charset, and other properties

By inspecting the output, you can verify the existing constraints and ensure that your expectations match the actual database configuration.

The above is the detailed content of How to Display Primary and Foreign Key Constraints for Specific Tables in MySQL?. For more information, please follow other related articles on the PHP Chinese website!