Show Create Table


This documentation has been retired and might not be updated. The products, services, or technologies mentioned in this content are no longer supported. See SHOW CREATE TABLE.

SHOW CREATE TABLE [db_name.]table_name

Return the command used to create an existing table. If the table does not exist, an exception is thrown.