title: Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
body: <p>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?</p>
  
  <p><strong>REASON FOR REQUEST:</strong></p>
  
  <p>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!</p>