How to generate a CREATE TABLE statement for a given table in SQLite

by

Posted on by

select sql from sqlite_master where type='table' and tbl_name='country'

See also:

How to generate a CREATE TABLE statement for a given table in SQL Server

How to generate a CREATE TABLE statement for a given table in Oracle

How to generate a CREATE TABLE statement for a given table in Mysql

Some SQLite tools you can try: https://www.withdata.com/sqlite/