Thursday, May 1, 2014

Query to find the latest modified tables in the database

SELECT name 'Table',modify_date 'Last Modified Date'
FROM sys.tables
WHERE  DATEDIFF(D,modify_date, GETDATE()) < 200

No comments: