views:

53

answers:

1

I use the following query to get information about columns of a SQL Table :

SELECT * from information_schema.columns 
WHERE table_name = 'userpersonalinformation'

but I can't find any data about creation date for each column ... Is there any way to get creation date of a column in a table ?

+4  A: 

I don't think that information is available in any system tables or the information schema views. I would look for that information in a source control system rather than the database.

dportas
Unfortunately it's not under source control
Space Cracker
Then I would fix that. sys.tables will tell you the last mod date of the table structure, but not the specific column.
dportas
You'd have to use sys.objects, not sys.tables
gbn
@gbn it just get me modified date for table ( many operations can cause this to be changed )
Space Cracker
@Space Cracker: yes, correct.
gbn