Last_Altered date from Information_Schema for Tables, Views, Idxs

• Express12

  SSCoach

  Points: 18514

  More actions

  January 27, 2010 at 6:05 am

  #215922

  The following query renders Last_Altered dates for programmabilty objects including stored procedures, functions, etc.

  Use my_database

  GO

  SELECT ROUTINE_NAME,ROUTINE_TYPE,CREATED,LAST_ALTERED

  FROM INFORMATION_SCHEMA.ROUTINES

  ORDER BY LAST_ALTERED DESC

  Is there a similar query I can use to identify Last_Altered dates for tables, views, indexes, etc?

  BT

• RSee

  SSC Journeyman

  Points: 82

  More actions

  January 28, 2010 at 7:03 am

  #1109960

  I tend to use the following:

  USE [DBName]

  SELECT name AS ObjectName

  , modify_date AS ModifiedDate

  , type AS ObjectType

  , type_desc AS TypeDescription

  FROM sys.all_objects

  More info on sys.all_objects is at: http://msdn.microsoft.com/en-us/library/ms178618.aspx

  There are also system catalog views specifically for tables, views, etc that have object specific info.

  Hope that helps,

  Randy