On 26 April 2010 18:30, sabapathy <sabapathy...@rediffmail.com> wrote: > > Yes currently it depends on the order. Should be checking if it can be > avoided. > > The issue has been resolved by the method you've suggested (INSERT INTO > new_table (col_1, col_3) > SELECT col_1, col_2 FROM old_table;) > > Thanks to everyone!! > > I am looking for how to get total no.of columns even if the table is empty..
Pragma table_info, see http://www.sqlite.org/pragma.html#pragma_table_info > > Thanks, > Sabapathy > Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
