If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Microsoft SQL Server > How To Delete All Tables

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #61 (permalink)  
Old 09-08-09, 10:25
pootle flump pootle flump is offline
King of Understatement
 
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
nitin - please don't answer threads that are years old, especially if linking to your blog. Feel free if the question is current, but not stuff like this.
__________________
Testimonial:
Quote:
pootle flump
ur codings are working excelent.
Reply With Quote
  #62 (permalink)  
Old 09-08-09, 10:49
MCrowley MCrowley is offline
Wage drone 24601
 
Join Date: Jan 2003
Location: Massachusetts
Posts: 4,899
But you have to credit him with picking one of the most entertaining threads in quite a while.
Reply With Quote
  #63 (permalink)  
Old 09-08-09, 11:15
pootle flump pootle flump is offline
King of Understatement
 
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
I just read all four pages. It sucked, you @55h0l3.
__________________
Testimonial:
Quote:
pootle flump
ur codings are working excelent.
Reply With Quote
  #64 (permalink)  
Old 09-08-09, 11:29
Thrasymachus Thrasymachus is offline
SQL Server Street Fighter
 
Join Date: Nov 2004
Location: Down The Rabbit Hole
Posts: 7,979
whats with the grump, flump? i think you need to apologize.
__________________
software development is where smart people go to waste their lives
Reply With Quote
  #65 (permalink)  
Old 09-08-09, 13:53
MCrowley MCrowley is offline
Wage drone 24601
 
Join Date: Jan 2003
Location: Massachusetts
Posts: 4,899
He is just grumpy that I called it a very entertaining thread, and he does not have any posts in it. He has a fever. And the only cure is more flump.
Reply With Quote
  #66 (permalink)  
Old 09-08-09, 14:19
Thrasymachus Thrasymachus is offline
SQL Server Street Fighter
 
Join Date: Nov 2004
Location: Down The Rabbit Hole
Posts: 7,979
Quote:
Originally Posted by MCrowley
He has a fever. And the only cure is more flump.
My priest always said that causes blindness. do we need 2 bruces?
__________________
software development is where smart people go to waste their lives
Reply With Quote
  #67 (permalink)  
Old 09-09-09, 03:20
pootle flump pootle flump is offline
King of Understatement
 
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
Quote:
Originally Posted by MCrowley
He has a fever. And the only cure is more flump.
^^^^^^^^^^this^^^^^^^^^^^
__________________
Testimonial:
Quote:
pootle flump
ur codings are working excelent.
Reply With Quote
  #68 (permalink)  
Old 09-10-09, 10:45
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,732
There is enough of me for all (the ladies).
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
Reply With Quote
  #69 (permalink)  
Old 09-12-09, 04:42
kaffenils kaffenils is offline
Registered User
 
Join Date: Nov 2005
Posts: 122
Quote:
Originally Posted by Saravanan.R
Hi All,

Sorry I have to DELETE (DROP ALL TABLES) in a single shot!
You could try:
exec sp_msforeachtable 'drop table ?'

Edit: old thread... sorry.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On