Use this statement to delete an index.
DROP INDEX [ table-name.]index-name
You cannot drop the primary index of a table.
UltraLite does not process requests or queries referencing the index while the DROP INDEX statement is being processed. Furthermore, you cannot execute DROP INDEX when the database includes active queries or uncommitted transactions.
For UltraLite.NET users: You cannot execute this statement unless you also call the Dispose method for all data objects (for example, ULDataReader). See Dispose method.
Statements are not released if schema changes are initiated at the same time. See Schema changes with DDL statements.
The following statement deletes a fictitious index, fin_codes_idx, on the FinancialData table:
DROP INDEX FinancialData.fin_codes_idx;
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|