You can perform the following operations on an existing sequence:
Dropping a Sequence
Individual or batch dropping can be performed on sequences. Refer to Batch Dropping Objects section for batch drop.
Follow the steps to dropping a sequence:
- Right-click the selected sequence and select Drop Sequence.
The Drop Sequence dialog box is displayed.
- Click Yes to drop the sequence.
The status bar displays the status of the completed operation.
Dropping a Sequence Cascade
Follow the steps to drop a sequence cascade:
- Right-click the selected sequence and select Drop Sequence Cascade.
The Drop Sequence Cascade dialog box is displayed.
- Click Yes to drop the sequence cascade.
The status bar displays the status of the completed operation.
This is only available for OLAP, not for OLTP.
Granting/Revoking a Privilege
Follow the steps to grant/revoke a privilege:
- Right-click selected sequence and select Grant/Revoke.
The Grant/Revoke dialog is displayed.
- Refer to Grant/Revoke Privilege to grant/revoke a privilege.