SHOW Statements 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 • Extra • 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 • Comment 2917 13.7.7.6 SHOW CREATE DATABASE Statement SHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS]  db_name mysql>  SHOW CREATE DATABASE test\G 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. Any additional information that is available about a given column. The value is nonempty in these cases: The privileges you have for the column. This value is displayed only if you use the  FULL  keyword. 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” . 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 .