You apply and enable a sequence on a column as follows:
-
Open the property sheet of the column to which you want to apply the sequence.
-
On the General tab, select a sequence from the Sequence list.
-
Click OK to close the property sheet.
-
Select to open the Rebuild Triggers dialog box.
-
Click the Selection tab and select the table or tables containing the column to which you want to attach a sequence.
-
Click OK.
The triggers are rebuilt and the sequence is enabled on the column.