Have a Question?

If you have any question you can ask below or enter what you are looking for!



Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement

Is there any way in which I can clean a database in SQl Server 2005 by dropping all the tables and deleting stored procedures, triggers, constraints and all the dependencies in one SQL statement?

REASON FOR REQUEST:

I want to have a DB script for cleaning up an existing DB which is not in use rather than creating new ones, especially when you have to put in a request to your DB admin and wait for a while to get it done!

  Devbrat Tripathi

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any