Deleting an Index

Use SAP Control Center to delete indexes created on user tables.

1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables > User Tables.
2. Click the Name field of the table, then click the drop-down arrow and select Properties.
3. In the left pane, click Indexes.
4. Click the Name field of the index, then click the drop-down arrow and select Delete.
5. Confirm the deletion.

   To zero out residual data, which may be visible to a user using the dbcc utility after you delete the index, select Erase Residual Data. You cannot use Erase Residual Data on indexes for tables that were created on a user database earlier than SAP ASE version 16.0.

6. Click Finish.