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:

  1. Right-click the selected sequence and select Drop Sequence.

    The Drop Sequence dialog box is displayed.

  2. 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:

  1. Right-click the selected sequence and select Drop Sequence Cascade.

    The Drop Sequence Cascade dialog box is displayed.

  2. 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:

  1. Right-click selected sequence and select Grant/Revoke.

    The Grant/Revoke dialog is displayed.

  2. Refer to Grant/Revoke Privilege to grant/revoke a privilege.