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

Download DB Pilot, the database GUI with a twist.
Speed up your SQL workflows today.