通过SQL语法查询所有表的最后更新时间

chixm

SELECT name, last_user_update

FROM sys.dm_db_index_usage_stats

INNER JOIN sys.tables ON sys.dm_db_index_usage_stats.object_id = sys.tables.object_id

WHERE database_id = DB_ID()

ORDER BY last_user_update DESC