SQL Statements and Extensions for the Salesforce Driver : Create Sequence

Create Sequence
Purpose
The Create Sequence statement creates an auto-incrementing sequence for a local table.
Syntax
CREATE SEQUENCE sequence_name [AS {INTEGER | BIGINT}] [START WITH start_value] [INCREMENT BY increment_value]
where:
sequence_name
Specifies the name of the sequence. By default, the sequence type is INTEGER.
start_value
Specifies the starting value of the sequence. The default start value is 0.
increment_value
Specifies the value of the increment; the value must be a positive integer. The default increment is 1.
Next Value For Clause

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.