DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) STATISTICS Table

Info Catalog (mysql.info.gz) COLUMNS Table (mysql.info.gz) INFORMATION_SCHEMA Tables (mysql.info.gz) USER_PRIVILEGES Table
 
 21.1.4 The `INFORMATION_SCHEMA STATISTICS' Table
 ------------------------------------------------
 
 The `STATISTICS' table provides information about table indexes.
 
 *Standard Name*               *`SHOW' name*          *Remarks*
 `TABLE_CATALOG'                                      `NULL'
 `TABLE_SCHEMA'                                       = Database
 `TABLE_NAME'                  `Table'                
 `NON_UNIQUE'                  `Non_unique'           
 `INDEX_SCHEMA'                                       = Database
 `INDEX_NAME'                  `Key_name'             
 `TYPE'                                               omit
 `SEQ_IN_INDEX'                `Seq_in_index'         
 `COLUMN_NAME'                 `Column_name'          
 `COLLATION'                   `Collation'            
 `CARDINALITY'                 `Cardinality'          
 `PAGES'                                              omit
 `FILTER_CONDITION'                                   omit
 `SUB_PART'                    `Sub_part'             MySQL extension
 `PACKED'                      `Packed'               MySQL extension
 `NULLABLE'                    `Null'                 MySQL extension
 `INDEX_TYPE'                  `Index_type'           MySQL extension
 `COMMENT'                     `Comment'              MySQL extension
 
 Notes:
 
    * There is no standard table for indexes. The preceding list is
      similar to what SQL Server 2000 returns for `sp_statistics', except
      that we replaced the name `QUALIFIER' with `CATALOG' and we
      replaced the name `OWNER' with `SCHEMA'.
 
      Clearly, the preceding table and the output from `SHOW INDEX' are
      derived from the same parent. So the correlation is already close.
 
 
 The following statements are equivalent:
 
      SELECT * FROM INFORMATION_SCHEMA.STATISTICS
        WHERE table_name = 'tbl_name'
        [AND schema_name = 'db_name'
 
      SHOW INDEX
        FROM tbl_name
        [FROM db_name]
 
Info Catalog (mysql.info.gz) COLUMNS Table (mysql.info.gz) INFORMATION_SCHEMA Tables (mysql.info.gz) USER_PRIVILEGES Table
automatically generated byinfo2html