August 22, 2005 at 1:53 pm
Where does SQL Server store the column descriptions? I have looked at several of the system tables (I thought they might be there) and I can't seem to find anything. Can I query something to see the column descriptions without looking at the table designs in Enterprize Manager?
Thanks--MP
August 22, 2005 at 2:04 pm
check out fn_listextendedproperty in BOLS.
They are kept in the syscomments table IIRC.
August 22, 2005 at 2:10 pm
Err >> SysProperties
August 22, 2005 at 2:43 pm
sysProperties, got it. Thanks!
August 22, 2005 at 2:46 pm
HTH.
August 22, 2005 at 3:13 pm
Here is some more info on the subject.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply