Applying and Enabling a Sequence on a Column

You apply and enable a sequence on a column as follows:

  1. Open the property sheet of the column to which you want to apply the sequence.
  2. On the General tab, select a sequence from the Sequence list.
  3. Click OK to close the property sheet.
  4. Select Tools > Rebuild Objects > Rebuild Triggers to open the Rebuild Triggers dialog box.
  5. Click the Selection tab and select the table or tables containing the column to which you want to attach a sequence.
  6. Click OK.

    The triggers are rebuilt and the sequence is enabled on the column.

For more information on rebuilding triggers, see Building Triggers and Procedures.