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     3444
  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 .Net developer having 4+ years of experience. He loves writting technical article for .Net developers. Najmul Hoda
No Photo
 
Country India
Company BirlaSoft
Home Page www.dotnetlogix.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   
  
    
 
Section sponsored by