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

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

SELECT sql FROM sqlite_master WHERE name = 'my_table';
Previous
Composite Primary Keys in SQLite
Next
How to Create a Table in DuckDB

Get started with DB Pilot

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

Download Learn more