User Id :    Password :      New Member   Forgot Password  
 
How to drop multiple tables in a single drop command in SQL SERVER
Description How to drop multiple tables in a single drop command.   No. of Views     3677
  Rating     4
Author Najmul Hoda   Posted On     18 Aug 2011
Tags SQL SERVER    

Sample Code   Download Code

 

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.

About Author

About Author He is a team lead, having 8+ years of experience. He loves writing technical article for .Net developers. Najmul Hoda
No Photo
 
Country United States
Company BirlaSoft
Home Page http://www.magixchat.com

Rate this article

Rating options from poor, fair, good, very good to excelent.  
 

Comments

 
 
Posted By Annonymous on 02 Sep 2011 at 04:54 PM
 
Got it! Thanks a lot again for helipng me out!
 
 
 
Posted By Shaheen on 18 Aug 2011 at 11:11 PM
 
Simple but nice Najmul. Thanks for sharing.
 
 
   
Write your comment here.
Comment
Verification Code