f2s_sequence_init¶
Applies to: Oracle, PostgreSQL Drivers
Syntax¶
f2s_sequence_init {filenumber}
Parameter |
Description |
|---|---|
file number |
The table number of the table to initialize the auto increment (usually in the form of Filename.File_Number) |
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¶
f2s_sequence_init Orders.File_Number