Skip to content

Instantly share code, notes, and snippets.

@randika

randika/gist:3377460

Created August 17, 2012 09:38
Show Gist options
  • Save randika/3377460 to your computer and use it in GitHub Desktop.
Save randika/3377460 to your computer and use it in GitHub Desktop.
Download ZIP
MSSQL Find table last modify dates
Raw
gistfile1.txt
SELECT name, modify_date
FROM sys.objects
WHERE type = 'P' order by modify_date desc
SELECT name, modify_date
FROM sys.tables
order by modify_date desc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment