Column Descriptions

Is there a way to get a list column names and their descriptions?

You can run sp_help (tablename) to get a full description of the table's columns along with other information.

Is this what you need?

|||

No.

In the design view of table one can apply a column description to a column is there a way to see that description?

|||

Using Books Online, refer to Topics:

Extended properties sp_addextendedproperty sp_updateextendedproperty sp_dropextendedproperty fn_listextendedproperty