The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table Profiling information is also available from the  SHOW PROFILE  and  SHOW PROFILES  statements. See Section 13.7.7.30, “SHOW PROFILE Statement” . For example, the following queries are equivalent: The  REFERENTIAL_CONSTRAINTS  table provides information about foreign keys. The  REFERENTIAL_CONSTRAINTS  table has these columns: 26.3.25 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table The name of the schema (database) to which the constraint belongs. The name of the catalog to which the constraint belongs. This value is always  def . The name of the constraint. The name of the catalog containing the unique constraint that the constraint references. This value is always  def . The name of the schema containing the unique constraint that the constraint references. The name of the unique constraint that the constraint references. The value of the constraint  MATCH  attribute. The only valid value at this time is  NONE . The value of the constraint  ON UPDATE  attribute. The possible values are  CASCADE ,  SET NULL ,  SET DEFAULT ,  RESTRICT ,  NO ACTION . The value of the constraint  ON DELETE  attribute. The possible values are  CASCADE ,  SET NULL ,  SET DEFAULT ,  RESTRICT ,  NO ACTION . The name of the table. This value is the same as in the  TABLE_CONSTRAINTS  table. The name of the table referenced by the constraint. • REFERENCED_TABLE_NAME • TABLE_NAME • DELETE_RULE • UPDATE_RULE • MATCH_OPTION • UNIQUE_CONSTRAINT_NAME • UNIQUE_CONSTRAINT_SCHEMA • UNIQUE_CONSTRAINT_CATALOG • CONSTRAINT_NAME • CONSTRAINT_SCHEMA • CONSTRAINT_CATALOG SHOW PROFILE FOR QUERY 2; SELECT STATE, FORMAT(DURATION, 6) AS DURATION FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID = 2 ORDER BY SEQ; 4812