dlamblin dlamblin - 4 years ago 111
SQL Question

How do I show the schema of a table in a MySQL database?

From the MySQL console, what command displays the schema of any given table?

Answer Source
describe [db_name.]table_name;

for formatted output, or

show create table [db_name.]table_name;

for the SQL statement that that could create it.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download