How to: Show Column Properties (Visual Database Tools)

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.

Note

To show properties for elements other than columns, such as tables and views, right-click the element and click Properties.

To show read-only column properties in the Properties window in Object Explorer

  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.

To show column properties in the Column Properties tab in Table Designer

  1. In Object Explorer, right-click the table to which you want to add columns and choose Design. The table opens in the 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.