SQL Server 中是否有函数/特性来确定表是否有任何(最近)活动? [英] Is there a function/feature in SQL Server to determine if a table has any (recent) activity?

问题描述

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

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

这篇关于SQL Server 中是否有函数/特性来确定表是否有任何(最近)活动?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！