Tag: DDL

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

    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/