Matching Oracle Sequences with Primary Keys

These rules are used to match an Oracle sequence to a primary key field for a table:

In both cases, the sequence owner must match the schema owner.

This is the automated algorithm. You can always change the sequence on the Database Properties screen in Iron Speed Designer.  Expand the Databases tab, select the table, and select the primary key.  You will see the Database Sequence dropdown list on the lower right section.  You can select any of the sequences from the database.

See Also

Oracle Database Support