I have been searching for a way to associate a description with a
column name. I have come across multiple posts regarding this
question. Problem is that I have seen two different answers.

One post mentioned using the undocumented system table named
sysproperties while other posts mentioned using the
sp_addextendedproperty (and fn_listextendedproperty).

Which one and why one over the other?

Thanks.

"Jason" <JayCallas@hotmail.com> wrote in message
news:f01a7c89.0402171022.72ae34c0@posting.google.c om...
> I have been searching for a way to associate a description with a
> column name. I have come across multiple posts regarding this
> question. Problem is that I have seen two different answers.
>
> One post mentioned using the undocumented system table named
> sysproperties while other posts mentioned using the
> sp_addextendedproperty (and fn_listextendedproperty).
>
> Which one and why one over the other?
>
> Thanks.

Use extended properties - that's what they are intended for. Microsoft does
not support direct modifications to system tables, and many of them
(including sysproperties) aren't documented.

See "System Tables" in Books Online.

Simon