See the most recently updated stored procs, tables & views

This group of similar queries return the object name, creation date and last modified date of various objects in the database.

-- Tables
SELECT name, create_date, modify_date
FROM sys.tables
ORDER BY modify_date DESC;

-- Procs
SELECT name, create_date, modify_date
FROM sys.procedures
ORDER BY modify_date DESC;

-- Views
SELECT name, create_date, modify_date
FROM sys.views
ORDER BY modify_date DESC;

-- Functions
SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'FN'
ORDER BY modify_date DESC;
Default image
Eric
Code guy.

Leave a Reply