2

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;

puifais
  • 738
  • 2
  • 9
  • 20

0 Answers0