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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy