You will have to do this with code. select name from sqlite_master where name like 'x%';
that will give you a list of all tables that start with x; you can then delete all tables with names in the result set. RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of baxy77bax Sent: Tuesday, February 03, 2009 4:08 AM To: sqlite-users@sqlite.org Subject: [sqlite] drop table question ? hi simple question : How to drop all tables in my database that start , for example, with X? table 1 is X1998 table 2 is X8676 table 3 is X2912 ... thanx -- View this message in context: http://www.nabble.com/drop-table-question---tp21806118p21806118.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users