Dropping an index

Dropping an index deletes it from the database.

You can use either Sybase Central or Interactive SQL to perform this task.

Sybase Central

In Sybase Central, you can perform this task while working with a selected database.

To drop an UltraLite index (Sybase Central)

  1. Connect to the UltraLite database.

  2. In the left pane, double-click Indexes.

  3. Right-click an index and then choose Delete.

  4. Click Yes.

Interactive SQL

In Interactive SQL, deleting a table is also called dropping it. You can perform this task with the DROP INDEX statement.

To drop an UltraLite index (Interactive SQL)

  1. Connect to a database.

  2. Execute a DROP INDEX statement.

    For example, the following statement removes the EmployeeNames index from the database:

    DROP INDEX EmployeeNames;
See also
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0