f2s_sequence_init¶
Applies to: Oracle, PostgreSQL Drivers
Syntax
f2s_sequence_init {table number}
Parameter |
Description |
|---|---|
table number |
The table number of the table to initialize the auto increment. |
Description
This command is used to initialize all auto increment columns, or sequences in Oracle or PostgreSQL, of the specified table to be the highest number plus one. This is useful when inserting a large amount of records in the table and the sequence is not being updated because the auto incremented column is being manually filled.
Example
- ** A simple example without using the optional Boolean variable or the “using” syntax**
f2s_sequence_init 10 1
Replaces: SQL_INITIALIZE_SEQUENCE