DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info) table-constraints-table

Info Catalog (mysql.info) collation-character-set-applicability-table (mysql.info) information-schema (mysql.info) key-column-usage-table
 
 20.12 The `INFORMATION_SCHEMA TABLE_CONSTRAINTS' Table
 ======================================================
 
 The `TABLE_CONSTRAINTS' table describes which tables have constraints.
 
 *`INFORMATION_SCHEMA' Name*   *`SHOW' Name*          *Remarks*
 `CONSTRAINT_CATALOG'                                 `NULL'
 `CONSTRAINT_SCHEMA'                                  
 `CONSTRAINT_NAME'                                    
 `TABLE_SCHEMA'                                       
 `TABLE_NAME'                                         
 `CONSTRAINT_TYPE'                                    
 
 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 is not available until we
      support `CHECK'.
 
Info Catalog (mysql.info) collation-character-set-applicability-table (mysql.info) information-schema (mysql.info) key-column-usage-table
automatically generated byinfo2html