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 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.

See Also

Other Resources

Working with Columns (Visual Database Tools)

Help and Information

Getting SQL Server 2005 Assistance