kalikoi
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment