Working with Sequences¶
You can perform the following operations on an existing sequence:
Dropping a Sequence¶
Individual or batch dropping can be performed on sequences. Refer to Dropping a Batch of 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.
Note
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.