Thursday, July 18, 2013

SQL SERVER Quick-N-Dirty All Tables with Dates

SELECT
    'U'
,    [name]
,    CAST (create_date AS DATE)
,    CAST (modify_date AS DATE)
FROM sys.tables
WHERE create_date > '2013-01-01'
UNION       
SELECT
    'V'
,    [name]
,    CAST (create_date AS DATE)
,    CAST (modify_date AS DATE)
FROM sys.views
WHERE create_date > '2013-01-01'
UNION
SELECT
    'P'
,    [name]
,    CAST (create_date AS DATE)
,    CAST (modify_date AS DATE)
FROM sys.procedures
WHERE create_date > '2013-01-01'
ORDER BY [name]


No comments: