How to view a table's CREATE TABLE statement in MySQL

Get the CREATE TABLE statement of an existing table called my_table:

SHOW CREATE TABLE my_table;
Previous
Composite Primary Keys in MySQL
Next
How to Create a Table in SQLite

Get started with DB Pilot

DB Pilot is a Database GUI client and SQL editor for PostgreSQL, MySQL, SQLite, DuckDB & more.

Download Learn more