How do I copy a SQLite table along with its index(es)? I know this works for other flavors of SQL but not SQLite :(
CREATE TABLE newtable LIKE oldtable;
INSERT newtable SELECT * FROM oldtable;
How do I copy a SQLite table along with its index(es)? I know this works for other flavors of SQL but not SQLite :(
CREATE TABLE newtable LIKE oldtable;
INSERT newtable SELECT * FROM oldtable;