Export (0) Print
Expand All

How to: Specify Computed Columns (Visual Database Tools)

You can specify an expression for a computed column in Table Designer. A computed column expression can use data from other columns to calculate a value for the column to which it belongs.

To specify a computed column

  1. In Object Explorer, right-click the table with columns for which you want to change the scale and click Design.

    The table opens in Table Designer.

  2. Select the column for which you want to specify a computed column formula.

  3. In the Column Properties tab, expand the Computed Column Specification property.

  4. In the (Formula) child property, type the expression for this column in the grid cell to the right.

  5. Indicate whether the data is persisted by choosing Yes or No from the drop-down for the Is Persisted child property.

    NoteNote

    If your database engine does not allow the persisting of expression results, you cannot choose Yes for the Is Persisted property.

The new computed column specification is assigned to the column in Table Designer after you click outside the grid cell or use the TAB key to move to another grid cell and changes are stored in the database when you save your changes in Table Designer.

Community Additions

ADD
Show:
© 2014 Microsoft