How to pull Column creation & lastmodified date.

• mr_adeelalisyed

  SSC-Addicted

  Points: 470

  More actions

  November 16, 2009 at 9:54 am

  #94039

  Hello experts,

  I’m trying to get all the available column’s creation date and also last modified date within database. I’ve tried to use the following without any luck.

  select * from sys.objects

  select * from sys.columns

  select * from information_schema.columns

  Does anybody know a way how I can get pull this information?

  Thanks a lot advance.

• mr_adeelalisyed

  SSC-Addicted

  Points: 470

  More actions

  November 16, 2009 at 10:15 am

  #1079783

  Hey guys, Nevermind I’ve able to write a select and join sys.object with sys.columns and accomplished what I needed. For reference here is my code.

  sp_msForEachdb

  'select

  ''?'',

  obj.name as TableName,

  col.name as ColumnName,

  obj.create_date as ColumnCreationDate,

  obj.modify_date as LastModifiedDate

  from ?.sys.objects obj

  inner join ?.sys.columns col

  on obj.object_id = col.object_id

  where type_desc = ''USER_TABLE'' '

  Thanks again.