Thursday, May 21, 2009

Get Modified Date of Table

Original Link 



 
DECLARE @n_days INT
DECLARE @n_days INT

SET @n_days = 10 --Give the number of days

SELECT
[name]
,create_date
,modify_date
FROM
sys.tables
WHERE modify_date > GETDATE() - @n_days
AND schema_id = 5
ORDER BY modify_date DESC

No comments: