EnterWorks - ETT 152 - How to Clean Up Obsolete Tables and Views from the EPIM Database

The EnterWorks application generates many tables and views dynamically based on the configuration within the EnterWorks data model and operations being performed, such as imports.  In some cases, these tables and views remain after they are no longer used or needed.  Over time, this can result in database table "bloat", increasing the time it takes to view the tables and views in a client tool such as SQL Server Management Studio as well as inflate the file size of the database and full backup files.  While these obsolete tables and views can be removed manually via SQL, ensuring they are no longer needed is time-consuming and error-prone, risking missing obsolete tables or views or worse, deleting tables or views that are still being used.  

A stored procedure has been created to list the obsolete tables and views and product the appropriate SQL to remove them.  When the generated SQL commands are executed, the obsolete tables and views will be removed.

This session identifies the possible obsolete tables and views identifies the sequence tables, describes the stored procedure in detail including how to use it.

Prerequisites - ETT 073