Wednesday, July 2, 2014
Get Table Names which are Modified in last few days in Sql Server
SELECT
name
'Table'
,
modify_date
'Last Modified Date'
FROM
sys
.
tables
WHERE
DATEDIFF
(
D
,
modify_date
,
GETDATE
())
<
15
Newer Post
Older Post
Home