Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Working with Database Objects » Working with indexes

Rebuilding indexes Next Page

Dropping indexes

If an index is no longer required, you can delete it from the database in Sybase Central or in Interactive SQL.

To drop an index (Sybase Central)

  1. Connect to the database as a DBA user or as the owner of the table on which the index is created.

  2. In the left pane, open the Indexes folder.

  3. Select the desired index and then choose Edit > Delete.

To drop an index (SQL)

  1. Connect to the database as a DBA user or as the owner of the table associated with the index.

  2. Execute a DROP INDEX statement.

    3. Example

    The following statement removes the EmployeeNames index from the database:

    DROP INDEX EmployeeNames;

    For more information, see DROP statement.