How to drop multiple tables in a single drop command in SQL SERVER
How to drop multiple tables in a single drop command.
Today one of my colleagues asked me “Is it possible to drop multiple tables in a single drop statement.” I just replied it should be but I am not sure.
Then I tried my self and it worked. Now I want to share this with you guys. See the below code its self explainatory.
DROP TABLE tbl1, tbl2, tbl3, tb4
It’s so simple. Isn’t it.