Post reply

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

  • 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,

  • 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

  • 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...

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply