SHOW CREATE TABLE
Show the definition that creates the specified table. The output includes two columns:
path: The path to the specified table.
sql_definition: The definition for the specified table.
note
You need the SELECT privilege on the table to retrieve the definition.
SHOW CREATE TABLE <table_name>
Parameters
<table_name> String
The name of the table whose definition you want to see.
Examples
Show the definition of a tableSHOW CREATE TABLE "company_data".employees