How can I get the description value displayed in a table column in table designer.
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
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
Rick Strahl has the answers on this link:
No one has followed this question yet.
Opening Database properties in SSMS fails with lock
Query Result : Max number of characters
disable square braces when generating scripts from SSMS
Help exporting results with the column names
What does the Net Address in Activity Monitor represent?