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 maintain the tables and objects of the SQL Database. In my organization, when we add
a new column or change the data type of a column, we export the data of the existing table in the backup table.
Often, we forgot to review and maintain those backup tables. So as a solution, we decided to create a SQL Job that
populates the list of unused tables and email the list to the DBA Team for review.
Read more »