On 2/15/2014 8:09 AM, J Trahair wrote:
[I often use the structure of a table to recreate the table as new from
scratch, or to clone it into a different table, eg. I have a table
called 'Customers', I want to have a table called 'Enquirers' with
exactly the same structure.
select sql from sqlite_master where type='table' and tbl_name='Customers';
gives you the CREATE TABLE statement with which Customers table was
created. Replace Customers with Enquirers, and run the statement.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users