Creates a new database sequence.
All sequences start at one and advance by one.
This is available in a network database and requires the star$define role.
Parameters:
| Name | Optional | Type | Description |
| sequence$ | Mandatory | Text | The name of the database sequence to be created. |
Examples:
SELECT create_sequence('mysequence'); -- creates a new sequence called 'mysequence'.
Tips:
- The star$sequences view indicates which sequences already exist.
Comments
Article is closed for comments.