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';

Get started with DB Pilot

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