How To Find Unused Tables in SQL Server

One of the first steps a good database administrator should take when looking at a database system is to find and remove unused indexes and tables in databases.

Before you remove the tables, you should send the unused table list to the application developer. It is safer to remove the tables after you get the application developer approval. Because there is a possibility that the table may be used only one day a year.

 You may also want to read the article “How To Find Unused Indexes in SQL Server” to find unused indexes.

The following script returns tables that have not been used for the last 1 month.