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.