How can I get the description value displayed in a table column in table designer.
asked
Description value in table designer
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
