March 4, 2009 at 11:19 am
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
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
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
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