- 19 INFORMATION_SCHEMA Tables
- 19.1 The INFORMATION_SCHEMA SCHEMATA Table
- 19.2 The INFORMATION_SCHEMA TABLES Table
- 19.3 The INFORMATION_SCHEMA COLUMNS Table
- 19.4 The INFORMATION_SCHEMA STATISTICS Table
- 19.5 The INFORMATION_SCHEMA USER_PRIVILEGES Table
- 19.6 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
- 19.7 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
- 19.8 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
- 19.9 The INFORMATION_SCHEMA CHARACTER_SETS Table
- 19.10 The INFORMATION_SCHEMA COLLATIONS Table
- 19.11 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
- 19.12 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
- 19.13 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
- 19.14 The INFORMATION_SCHEMA ROUTINES Table
- 19.15 The INFORMATION_SCHEMA VIEWS Table
- 19.16 The INFORMATION_SCHEMA TRIGGERS Table
- 19.17 The INFORMATION_SCHEMA PLUGINS Table
- 19.18 The INFORMATION_SCHEMA ENGINES Table
- 19.19 The INFORMATION_SCHEMA PARTITIONS Table
- 19.20 The INFORMATION_SCHEMA EVENTS Table
- 19.21 The INFORMATION_SCHEMA FILES Table
- 19.22 The INFORMATION_SCHEMA PROCESSLIST Table
- 19.23 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
- 19.24 The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables
- 19.25 The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables
- 19.26 The INFORMATION_SCHEMA PROFILING Table
- 19.27 Other INFORMATION_SCHEMA Tables
- 19.28 Extensions to SHOW Statements
The REFERENTIAL_CONSTRAINTS table
provides information about foreign keys.
INFORMATION_SCHEMA
Name |
SHOW
Name |
Remarks |
| CONSTRAINT_CATALOG | NULL | |
| CONSTRAINT_SCHEMA | ||
| CONSTRAINT_NAME | ||
| UNIQUE_CONSTRAINT_CATALOG | NULL | |
| UNIQUE_CONSTRAINT_SCHEMA | ||
| UNIQUE_CONSTRAINT_NAME | ||
| MATCH_OPTION | ||
| UPDATE_RULE | ||
| DELETE_RULE | ||
| TABLE_NAME | ||
| REFERENCED_TABLE_NAME |
Notes:
The
REFERENTIAL_CONSTRAINTStable was added in MySQL 5.1.10. TheREFERENCED_TABLE_NAMEcolumn was added in MySQL 5.1.16.TABLE_NAMEhas the same value asTABLE_NAMEinINFORMATION_SCHEMA.TABLE_CONSTRAINTS.CONSTRAINT_SCHEMAandCONSTRAINT_NAMEidentify the foreign key.UNIQUE_CONSTRAINT_SCHEMA,UNIQUE_CONSTRAINT_NAME, andREFERENCED_TABLE_NAMEidentify the referenced key. (Note: Before MySQL 5.1.16,UNIQUE_CONSTRAINT_NAMEincorrectly named the referenced table, not the constraint.)The only valid value at this time for
MATCH_OPTIONisNONE.The possible values for
UPDATE_RULEorDELETE_RULEareCASCADE,SET NULL,SET DEFAULT,RESTRICT,NO ACTION.
User Comments
on windows, the values of referenced_table_name column are always in lowercase, even if you set lower_case_table_names = 0.
Add your own comment.