Working with Sequences

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.

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.