question

Alex Ratcliffe avatar image
Alex Ratcliffe asked

Description value in table designer

How can I get the description value displayed in a table column in table designer.

sql-serverssmstable-designer
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered

If you mean how do you get the value of 'Description' that you have entered via the Table Designer, then look in the system view sys.extended_properties.

major_id will match against the object_id from sys.columns of the column you are interested in

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Melvyn Harbour 1 avatar image
Melvyn Harbour 1 answered

Rick Strahl has the answers on this link:

http://www.west-wind.com/Weblog/posts/237339.aspx

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.