Export (0) Print
Expand All

Setting Column Properties

You can set or change the properties of a column.

To set column properties in a database diagram

  1. In your database diagram, select the table whose column properties you want to define.

  2. Right-click the table and choose Properties from the shortcut menu.

  3. Select the Columns tab.

  4. For each property you want to change, modify the value or setting.

  5. Click Close to close the property page.

The new setting takes effect in the database diagram as soon as you press the TAB key or click outside the cell in the Properties dialog box. The new setting is saved in the database when you save the table or your diagram.

Note   If a column property is visible on the database diagram, you can edit that property value directly — without opening the property page.  For information about controlling which column properties are visible on a diagram, see Changing a Table View in a Database Diagram.

To set column properties in Table Designer

  1. Open the Table Designer for the table containing the column whose property you want to modify.

  2. To set a fundamental property, click in the grid cell for that property of the database column you want to modify, then enter the value.
    -or-
    To set another property, select the grid row describing the database column you want to modify, then modify the property in the tab appearing below the grid.

The new setting takes effect in the database diagram as soon as you press the TAB key or click outside the edited grid cell or control. The new setting is saved in the database when you save the table or your diagram.

See Also

Column Properties

Show:
© 2014 Microsoft