If more than one of the Key  values applies to a given column of a table, Key  displays the one with the highest priority, in the order PRI , UNI , MUL . 

A UNIQUE  index may be displayed as PRI  if it cannot contain NULL  values and there is no PRIMARY KEY  in the table. A UNIQUE  index may display as MUL  if several columns form a composite UNIQUE index; although the combination of the columns is unique, each column can still hold multiple occurrences of a given value. 

• Default 

The default value for the column. This is NULL  if the column has an explicit default of NULL , or if the column definition includes no DEFAULT  clause. 

• Extra 

Any additional information that is available about a given column. The value is nonempty in these cases: 

• auto_increment  for columns that have the AUTO_INCREMENT  attribute. 

• on update CURRENT_TIMESTAMP  for TIMESTAMP  or DATETIME  columns that have the ON UPDATE CURRENT_TIMESTAMP  attribute. 

• VIRTUAL GENERATED  or VIRTUAL STORED  for generated columns. 

• DEFAULT_GENERATED  for columns that have an expression default value. 

• Privileges 

The privileges you have for the column. This value is displayed only if you use the FULL  keyword. 

• Comment 

Any comment included in the column definition. This value is displayed only if you use the FULL keyword. 

Table column information is also available from the INFORMATION_SCHEMA COLUMNS  table. See Section 26.3.8, “The INFORMATION_SCHEMA COLUMNS Table” . The extended information about hidden columns is available only using SHOW EXTENDED COLUMNS ; it cannot be obtained from the COLUMNS  table. 

You can list a table’s columns with the mysqlshow db_name tbl_name  command. 

The DESCRIBE  statement provides information similar to SHOW COLUMNS . See Section 13.8.1, “DESCRIBE Statement” . 

The SHOW CREATE TABLE , SHOW TABLE STATUS , and SHOW INDEX  statements also provide information about tables. See Section 13.7.7, “SHOW Statements” . 

## 13.7.7.6 SHOW CREATE DATABASE Statement 

SHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name 

Shows the CREATE DATABASE  statement that creates the named database. If the SHOW  statement includes an IF NOT EXISTS  clause, the output too includes such a clause. SHOW CREATE SCHEMA  is a synonym for SHOW CREATE DATABASE . 

mysql> SHOW CREATE DATABASE test\G 

