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
name
- The name of the table or view to be used for SHOW CREATE TABLE.