SHOW CREATE TABLE
Description
SHOW CREATE TABLE
returns the CREATE TABLE statement or CREATE VIEW statement that was used to create a given table or view. SHOW CREATE TABLE
on a non-existent table or a temporary view throws an exception.
Syntax
Parameters
table_identifier
-
Specifies a table or view name, which may be optionally qualified with a database name.
Syntax:[ database_name. ] table_name