If an index is no longer required, you can delete it from the database in Sybase Central or in Interactive SQL.
Connect to the database as a user with DBA authority, or as the owner of the table on which the index is created.
In the left pane, double-click Indexes.
Right-click the index and choose Delete.
Connect to the database as a user with DBA authority, or as the owner of the table associated with the index.
Execute a DROP INDEX statement.
The following statement removes the EmployeeNames index from the database:
DROP INDEX EmployeeNames;
See DROP INDEX statement.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|