On 4/02/2009 12:06 AM, Brad Stiles wrote: >> sqlite> select 'drop table ' || name || ';' from sqlite_master where >> type = 'table' and name glob 'X[0-9][0-9][0-9][0-9]' order by 1; > > For my own edification, why the "order by 1" clause?
To sort them in ascending order of table name, which might make old-fashioned capers like visual scrutiny a little easier. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users