Creating a Sequence 

Use

You can use SQL Studio to create new sequences in the database.

Prerequisites

You have the necessary user authorizations and have user attribute NOT EXCLUSIVE*.

Procedure

...

Choose Catalog Manager ® New ® Sequence.

Enter a name for the sequence, and define the required values.

Choose Sequence Definition ® Create Sequence.

To export the SQL statement for creating the sequence to the SQL dialog, choose Sequence Definition ® Export to SQL Dialog.

 

*For an explanation of user authorizations and user attributes, see the User Concept section of the documentation The SAP DB Database System and the Authorization section of the Reference Manual: SAP DB.

For information on the syntax of CREATE SEQUENCE statements, see the CREATE SEQUENCE Statement section of the Reference Manual: SAP DB.