`SHOW CREATE TABLE`¶

Shows the CREATE TABLE statement that creates the named table.

Table of contents

Synopsis
Description
Parameters

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.