I want to delete total tables at time ?

i want to delete total database from MYSQL server(remove the entire table) Generally Ex: delete * from table_name; it is deleted Particular table. But I want to delete Number of table's at a time? it is Possible or Not?

asked Oct 02 '12 at 05:20 PM in Default

veerivirus
0 ● 2

You want to use one statement to delete data from multiple tables? Or you want to remove the entire table?

Oct 02 '12 at 05:26 PM ThomasRushton ♦

Oh, and why have you mentioned MySQL in the query, but tagged your question with multiple versions of SQL Server rather than MySQL?

Oct 02 '12 at 05:27 PM ThomasRushton ♦

re-tagged as mysql.

Please add more to your question so that we can answer your problem

Oct 02 '12 at 09:44 PM Fatherjack ♦♦

(comments are locked)

2 answers:

I don't believe so. Any process that attempts to simulate this is actually running the individual DELETE statements behind the scenes. This would be true of SQL Server, too, by the way.

answered Oct 03 '12 at 12:50 PM

K. Brian Kelley
933 ● 2

(comments are locked)

SQL doesn't really work like that. You basically work at an entity level... column/table/dB. Regardless of that you wouldn't see much difference execution wise between one multi-table kind of command and multiple single commands. EDIT

For removing a database you can try this:
SET FOREIGN_KEY_CHECKS = 0;
DROP DATABASE dB_name;

answered Oct 03 '12 at 01:09 PM