To drop all tables, yes do a drop database. To drop all with something like a exclude, no. What you can do is an export of the tables you don't want to drop, then do a drop database + create database + import
Marc. -----Message d'origine----- De : Nitin Mehta [mailto:[EMAIL PROTECTED] Envoyé : vendredi 16 janvier 2004 06:28 À : [EMAIL PROTECTED] Objet : is this possible? hello everybody, i was wondering, if there's a single command to drop all or selected tables from the database, something like, where i can give the table names (1-2-3) not to be deleted. Thanx in advance Nitin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]