資料分析，需要獲取資料每一張表的最后訪問，修改，更新，掃描時間等：
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
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/226592.html
標籤：其他
上一篇：mysql 5.7.28 中GROUP BY報錯問題 SELECT list is not in GROUP BY clause and contains no
下一篇：mysql 5.7.28 中GROUP BY報錯問題 SELECT list is not in GROUP BY clause and contains no