Applying and Enabling a Sequence on a Column

You apply a sequence to a column from the column property sheet and enable it using the Rebuild Triggers command.

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 (see Building Triggers and Procedures).
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.