資料分析，需要獲取資料每一張表的最后訪問，修改，更新，掃描時間等：
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/226584.html
標籤：其他
上一篇：MySQL保存微信昵稱中的特殊符號造成：（Incorrect string value: "xxxx'for column ‘name’ at row 1）例外
下一篇：計算經歷的時間