数据分析,需要获取数据每一张表的最后访问,修改,更新,扫描时间等:
![获取数据表最后最后访问,修改,更新,扫描时间 获取数据表最后最后访问,修改,更新,扫描时间](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuam13d3cubmV0L3VwbG9hZHMvYWxsaW1nLzIwMjAvMi95TWptZWkuZ2lm.gif?w=700&webp=1)
![获取数据表最后最后访问,修改,更新,扫描时间 获取数据表最后最后访问,修改,更新,扫描时间](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuam13d3cubmV0L3VwbG9hZHMvYWxsaW1nLzIwMjAvMi8yVVpmaXUuZ2lm.gif?w=700&webp=1)
SELECT [Table Name] = [name],[Create Date] = create_date,[Modify Date] = modify_date,[Last User Update] = last_user_update,[Last User Scan] = last_user_scan FROM sys.tables AS t INNER JOIN (SELECT [TableName] = OBJECT_NAME(object_id),last_user_update, last_user_scan FROM sys.dm_db_index_usage_stats WHERE database_id = DB_ID(‘Test‘)) AS sd ON (t.[name] = sd.[TableName]) GOSource Code