how to find column creation date and modified date in mssql 2005

• chukostar

  Old Hand

  Points: 331

  More actions

  March 4, 2009 at 11:19 am

  #131427

  is there any possible way to identify the column's creation date & modified date?

  sys.tables & sys.databases don't seem to work.. thanks,

• beezell

  Hall of Fame

  Points: 3112

  More actions

  March 4, 2009 at 11:32 am

  #953462

  Try using the sys.sysobjects table. The object_id will be referenced in the systable and syscolumn if you need to look up other information. I believe the crdate is the create date.

  Cheers,

  Brian

• chukostar

  Old Hand

  Points: 331

  More actions

  March 4, 2009 at 12:16 pm

  #953501

  I think crdate from sysobjects is for table, not column.

  I also looked at INFORMATION_SCHEMA.COLUMNS, but there is no creation date

  any other suggestion...

• beezell

  Hall of Fame

  Points: 3112

  More actions

  March 4, 2009 at 12:22 pm

  #953507

  I'm pretty sure you can't get that for the column level. The best you can do is at the table level. Pretty much everything you need (and by need I mean "can") to know can be achieved through the sp_help function for a table's metadata.

  EXECUTE sp_help 'tablename';

  What exactly do you need the information for?

  Cheers,

  Brian