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)Use the SQL Anywhere 12 plug-in to 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.
Click Yes.
♦ To drop an index (SQL)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.
Example |
Discuter à propos de cette page dans DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |