How to: Show Column Properties (Visual Database Tools)

Updated: 12 December 2006

You can display read-only properties for both tables and views in the Properties window using Object Explorer. You can edit column properties in the Column Properties tab of Table Designer.

ms189608.note(en-US,SQL.90).gifNote:
To show properties for elements other than columns, such as tables and views, right-click the element and click Properties.

  1. Expand the table or view with column properties you want to see.

  2. Right-click a column in the tree under the table or view and click Properties.

    The Properties window updates to show the properties of the selected column.

  1. In Object Explorer, right-click the table for which you want to show column properties and choose Design (Modify in SP1 or earlier). The table opens in Table Designer.

  2. In Table Designer, select the column with properties you want to view or edit.

    The properties of the column appear in the Column Properties tab of Table Designer.

Community Additions

ADD
Show: