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]
Thursday, July 18, 2013
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment