(mysql.info.gz) TABLE_CONSTRAINTS Table

Info Catalog

(mysql.info.gz) COLLATION_CHARACTER_SET_APPLICABILITY Table

(mysql.info.gz) INFORMATION_SCHEMA Tables

(mysql.info.gz) KEY_COLUMN_USAGE Table

 
 21.1.12 The `INFORMATION_SCHEMA TABLE_CONSTRAINTS' Table
 --------------------------------------------------------
 
 The `TABLE_CONSTRAINTS' table describes which tables have constraints.
 
 *Standard Name*               *`SHOW' name*          *Remarks*
 `CONSTRAINT_CATALOG'                                 `NULL'
 `CONSTRAINT_SCHEMA'                                  
 `CONSTRAINT_NAME'                                    
 `TABLE_CATALOG'                                      omit
 `TABLE_SCHEMA'                                       
 `TABLE_NAME'                                         
 `CONSTRAINT_TYPE'                                    
 `IS_DEFERRABLE'                                      omit
 `INITIALLY_DEFERRED'                                 omit
 
 Notes:
 
    * The `CONSTRAINT_TYPE' value can be `UNIQUE', `PRIMARY KEY', or
      `FOREIGN KEY'.
 
    * The `UNIQUE' and `PRIMARY KEY' information is about the same as
      what you get from the `Key_name' field in the output from `SHOW
      INDEX' when the `Non_unique' field is `0'.
 
    * The `CONSTRAINT_TYPE' column can contain one of these values:
      `UNIQUE', `PRIMARY KEY', `FOREIGN KEY', `CHECK' This is a `CHAR'
      (not `ENUM') column.  The `CHECK' value will not be possible until
      we support `CHECK'.
 
 

Info Catalog

(mysql.info.gz) COLLATION_CHARACTER_SET_APPLICABILITY Table

(mysql.info.gz) INFORMATION_SCHEMA Tables

(mysql.info.gz) KEY_COLUMN_USAGE Table