In this article, I am going to demonstrate how we can identify the unused tables of a given SQL database. As a database administrator, we must keep an audit of the database objects. You are administrating a database that has hundreds of tables and some of them are huge. While upgrading the application, usually new tables are added to the database, and required data will be copied from old tables to new tables. We will discuss that in some other article.
The problem is after an application upgrade, the old tables are left unattended. If those tables are large, they