In some conditions, we have the requirement of remove all user defined tables, user defined stored procedure and triggers from a particular database.
Demo & Full Guide
MSSQL Server 2008 remove all tables and stored procedures from database remove all tables and data from database remove all triggers remove all views drop all triggers drop all views