View Single Post
  #9 (permalink)  
Old 04-03-04, 22:52
derrickleggett derrickleggett is offline
Registered User
 
Join Date: Apr 2004
Location: Kansas City, MO
Posts: 734
Quote:
Originally posted by blindman
"Its not a appropriate way to drop!"???????

What they heck WOULD be an appropriate way to drop all the tables in a database with dependent procedures, views, functions, and perhaps even triggers?

I have trouble believing what you are doing is appropriate or necessary in the first place!
If he's dropping the tables to just recreate them, the biggest problem will be the foreign keys if he has them.
__________________
MeanOldDBA
derrickleggett@hotmail.com
When life gives you a lemon, fire the DBA.
Reply With Quote