Chapter 3 Building Physical Diagrams

Applying and enabling a sequence on a column

To apply and enable a sequence on a column:

1. Select Model→Columns to display the List of Columns.
2. Click a column to which you want to apply a sequence.
   
   An arrow appears at the beginning of the line.
3. Double-click the arrow at the beginning of the line.
   
   or
   
   Click the Properties tool.
   
   The Column Property sheet opens to the General page.
4. Select a sequence from the Sequence dropdown listbox.
5. Click OK in each of the dialog boxes.
   
   You have applied the sequence to the column.
6. Select Tools→Rebuild Objects→Rebuild Triggers to display the Rebuild Triggers dialog box.
7. Click the Selection tab to display the Selection page.
8. Select the table containing the column to which you want to attach a sequence, and deselect the tables to which you do not want to attach a sequence.
9. Click OK.
   
   The triggers are rebuilt and the sequence is enabled on the column.

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

Copyright (C) 2005. Sybase Inc. All rights reserved.