Unused, Empty Table Detected
This warning has been shown because the table is empty and has had no reads performed against it. This implies that the table isn't necessary, for whatever applications are run against the database.
⚠ This warning is purely based on SQL Server's statistics, which are only populated by querying of the database. If the database has just been restarted or restored, or it's a replica database that is never used for selects, then the statistics will not accurately represent whether the index is used or not.
💡 Select 'Suggested Script' for an automatically generated script.
Investigate why the table hasn't been used and if it's referenced by any code. If not, consider dropping the unused, empty table.
How To Drop and Unused/Empty Table
DROP TABLE TableName;
DROP TABLE (Transact-SQL) | Microsoft Docs
sys.dm_db_index_usage_stats (Transact-SQL) | Microsoft Docs