Show Create Table

Important

This documentation has been retired and might not be updated. The product, service, or technology mentioned in this content is 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.