471,090 Members | 1,357 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,090 software developers and data experts.

sp_addextendedproperty versus sysproperties

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.
Jul 20 '05 #1
1 5522

"Jason" <Ja*******@hotmail.com> wrote in message
news:f0**************************@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
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Dieter Vanderelst | last post: by
33 posts views Thread by Joshua D. Drake | last post: by
2 posts views Thread by Andrew Robinson | last post: by
135 posts views Thread by Xah Lee | last post: by
42 posts views Thread by John Doty | last post: by
13 posts views Thread by blangela | last post: by
4 posts views Thread by aj | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.