Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » Working with UltraLite Databases » Working with UltraLite indexes

Adding UltraLite indexes Next Page

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 these tasks while working with a selected database.

To drop an UltraLite index (Sybase Central)
  1. Connect to the UltraLite database.

  2. Open the Indexes folder.

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

Interactive SQL

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

To drop an UltraLite index (Interactive SQL)
  1. Connect to a database.

  2. Execute a DROP INDEX statement.

    Example    The following statement removes the EmployeeNames index from the database:

    DROP INDEX EmployeeNames
  3. See also