取得資料表時間戳記(TIMESTAMP)

資料表異動的時間戳記(TIMESTAMP)語法

SELECT OBJECT_NAME(OBJECT_ID) AS DB_NAME, DATEDIFF(SECOND,'1970-1-1',LAST_USER_UPDATE) AS TABLE_TIMESTAMP
FROM SYS.DM_DB_INDEX_USAGE_STATS
WHERE DATABASE_ID = DB_ID( '資料庫' )
AND OBJECT_ID = OBJECT_ID( '資料表' )