Hey I have a question. Is it possible to enummerate all the column names of a table? I'm trying to create a copy of a table, and I want to cycle through all column names of the existing table, and manually create another table with the same column names.
The MySQL Copy table function:
CREATE TABLE new_table SELECT * FROM old_table;
would be perfect, but it seems SQLite doesn't have the equivalent.
Thanks for any help!
The MySQL Copy table function:
CREATE TABLE new_table SELECT * FROM old_table;
would be perfect, but it seems SQLite doesn't have the equivalent.
Thanks for any help!