Auto-incremented columns

The DB Sync database schema editor allows you to define properties of auto increment columns:



To apply auto incrementation to a primary key column of the current selected table:

  1. In the list on the left, select the SQL table to apply the edits to.

  2. Go to the Auto Increment panel.

  3. Enter a Name for the auto increment specification.

  4. Specify the name of the auto incremented column in the Column field.

  5. Select the type of auto-increment from the Kind options:
    • serial: Defines an Informix-style SERIAL column.
    • bigserial: Defines an Informix-style BIGSERIAL column.
    • sequence: Defines a column with values genereated from a SEQUENCE.
    • link: Defines a column with values copied from an auto-incremented column of a referenced master table.

  6. If needed, use the Start field to specify a starting value for serial, bigserial or sequence.

  7. In the Origin field:
    • When using a sequence, specify the name of the sequence object.
    • When using a link, specify the name of the referenced table and column

  8. Click Save.