December 7, 2005 at 9:38 am
hello, was wondering if there is a way to document columns with some descriptions. For example, if i have a column 'Status' in some table, that holds numeric values 0,1,2,3 where 0 means bad, 1 - average, 2 - good, 3 - excellent. i want to document that column in my own words in such a way that every new programmer would understand what the column values mean and what the valid values are. In other words, i am asking is there a way to write some documentation for each column, table, etc? I know there are ways to do it, by using some other lookup table or something like that, but i m wondering if there is any inbuilt support for documenting the columns. thanx for any response.
December 8, 2005 at 2:45 am
see sp_addextendedproperty in BOL
December 8, 2005 at 6:23 am
thank you, thats exactly wat i was looking for.
December 8, 2005 at 2:55 pm
There is a Description property available for each field and table in either Enterprise Manager or Management Studio. It's an simply an extended property named "Description". sp_addextendedproperty will let you add any number of extended properties using any name you like to objects, but only the "Description" property will show up in the table design boxes.
Also if you use Generate SQL Script to copy table structure make sure you check "Include extended properties".
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply