Assigning a Sequence to a Column

You can select a sequence from the Sequence list on the General tab of a column property sheet. You must enable sequences with the Rebuild Triggers command.

  1. Open the property sheet of a column with a numeric data type, and select a sequence in the Sequence list on the General tab.
  2. Click OK to save the change and return to your model.
  3. Select Tools > Rebuild Objects > Rebuild Triggers to open the Rebuild Triggers dialog (see Rebuilding Triggers).
  4. Click the Selection tab and select the tables containing the column to which you have assigned the sequence.
  5. Click OK to rebuild the triggers and enable the sequence on the column.