SQL Server 中是否有函数/特性来确定表是否有任何(最近)活动?

2021-09-10 00:00:00 tsql sql-server

我正在尝试清理数据库并想确定不再需要哪些表以便我可以删除它们.

I'm trying to clean up a database and want to determine which tables are no longer needed so I can drop them.

(SQL Server 2000)

提前致谢！

推荐答案

是的 - 这样的查询应该会为您提供所需的信息:

Yes - a query such as this should give you the information you need:

SELECT 
        last_user_seek,
        last_user_scan
    FROM
        sys.dm_db_index_usage_stats
    WHERE
        database_id = DB_ID() and object_id = object_id('tablename')

SQL 2000 更新:否 - 我相信在 SQL 2000 中没有获取这些信息的内置方式

Update for SQL 2000: No - I believe there's no built in way of getting this information in SQL 2000

相关文章