Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

You can drop multiple tables using single DROP statement

Jun 10 2011 4:43AM by Madhivanan   

Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement

DROP table test1,test2,test3
Read More..   [32134 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


Madhivanan
3 · 40% · 12947
58
 
7
 
55
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

18  Comments  

  • I never knew this! Thanks for sharing this.

    commented on Jun 10 2011 10:33AM
    Jacob Sebastian
    1 · 100% · 32235
  • I have seen quirky updates before, but not quirky deletes. This is great, and very useful!

    Thank-you for this wonderful find!

    commented on Jun 10 2011 11:34AM
    Nakul Vachhrajani
    4 · 36% · 11645
  • Self experiment is a great source of knowledge! thanks

    commented on Jun 11 2011 12:13PM
    Rui Carvalho
    44 · 4% · 1326
  • Everyone, Thanks for the feedback

    commented on Jun 13 2011 2:15AM
    Madhivanan
    3 · 40% · 12947
  • Tried with procedures & databases and works well :)

    DROP PROCEDURE Procedure1, Procedure2, Procedure3 GO

    DROP DATABASE DB1, DB2, DB3 GO

    I think, it works pretty much with anything that you can drop using DROP statement.

    commented on Jun 20 2011 12:42PM
    Dattatrey Sindol (Datta)
    42 · 4% · 1336
  • Thanks Madhi and Datta.

    But we cant use truncate like this.

    TRUNCATE table1, table2, table3.

    commented on Jun 22 2011 4:54AM
    Pothiraj
    26 · 6% · 1962
  • Pothiraj, yes truncate can not be used that way

    commented on Jun 22 2011 4:57AM
    Madhivanan
    3 · 40% · 12947
  • Good to know. Thanks for sharing

    commented on Jun 30 2011 5:53AM
    Hardik Doshi
    20 · 9% · 2864
  • very simple but powerful tip

    commented on Jul 6 2011 4:20AM
    Deepak kelath
    210 · 1% · 222
  • Thank you for good TIP thanks for sharing.

    commented on Jul 13 2011 12:53AM
    Abhijeet Desai
    328 · 0% · 129
  • Excellent tip.. thanks..

    commented on Aug 22 2011 7:37AM
    Hari Kumar
    236 · 1% · 190
  • Thanks both of you, I really find useful stuff, thanks again for sharing.

    commented on Aug 27 2011 12:31PM
    Haresh Ambaliya
    121 · 1% · 428
  • Grt! Thanks for sharing this.

    commented on Nov 29 2011 5:48AM
    Yogesh Kamble
    142 · 1% · 349
  • Nice Tips, Thanks for sharing !

    commented on Jan 12 2012 10:23AM
    Raghunath Bhandari
    186 · 1% · 253
  • Thanks for your sharing

    commented on Feb 25 2012 3:07AM
    Guru Samy
    9 · 16% · 5043
  • I never knew this, thanks for sharing!

    commented on Feb 29 2012 3:27AM
    Nilesh
    1253 · 0% · 20
  • Thanks for NEW sharing..

    commented on Jul 26 2012 9:56PM
    Jagdish Ilasariya
    2047 · 0% · 8
  • thanks for sharing............

    commented on Oct 3 2012 1:37AM
    Nirav Gandhi
    38 · 5% · 1567

Your Comment


Sign Up or Login to post a comment.

"You can drop multiple tables using single DROP statement" rated 5 out of 5 by 58 readers
You can drop multiple tables using single DROP statement , 5.0 out of 5 based on 58 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]