SHOW CREATE TABLE
You are viewing an old version of this article. View
the current version here.
Syntax
SHOW CREATE TABLE tbl_name
Description
Shows the CREATE TABLE statement that created the given
table. The statement requires the SELECT privilege
for the table. This statement also works with views.
SHOW CREATE TABLE
quotes table and
column names according to the value of the sql_quote_show_create server system variable.
MariaDB and MySQL specific table options, column options and index options are not included in the output of this statement if the NO_TABLE_OPTIONS
, NO_FIELD_OPTIONS
and NO_KEY_OPTIONS
SQL_MODE flags are used.
Examples
SHOW CREATE TABLE t\G *************************** 1. row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int(11) NOT NULL AUTO_INCREMENT, `s` char(60) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1
With sql_quote_show_create off:
SHOW CREATE TABLE t\G *************************** 1. row *************************** Table: t Create Table: CREATE TABLE t ( id int(11) NOT NULL AUTO_INCREMENT, s char(60) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.