From time to time the event where objects need to be cleared from a database without dropping the entire database and re-creating it may arise.  This script works to drop all user defined data types, tables, foreign keys, views, functions, constraints and stored procedures from the database executed against.  This script may need to be extended to include any object types not listed that may reside within your database.

[Read more...]