SHOW CREATE TABLE
Shows the CREATE TABLE
statement that creates the named table.
Table of Contents
Synopsis
SHOW CREATE TABLE table_ident
Description
SHOW CREATE TABLE
can be used to dump the schema of an existing user-created table.
It is not possible to invoke SHOW CREATE TABLE
on blob tables or system tables.
Parameters
table_ident: | The name (optionally schema-qualified) of the table which should be printed. |
---|