drop index

Description

Removes an index from a table in the current database.

Syntax

drop index table_name.index_name 
 [, table_name.index_name]...

Usage

Component Integration Services processes drop index when the table involved has been created as a proxy table. The actual table and index reside on a remote server. Component Integration Services forwards the request to the remote server, and removes the index from the proxy table.
When Component Integration Services forwards drop index to a remote server, the table name used is the remote table name, and the index names used are the remote index names. These names may not be the same as the local proxy table names.
If multiple indexes are dropped in a single command, each index is sent as an individual drop index command.
Trace flag 11208 changes the behavior of drop index. If trace flag 11208 is turned on, drop index is not sent to the remote server. Instead, Adaptive Server processes the command locally, as if the table on which it operates is local. This is useful for synchronizing the local Adaptive Server schema with the schema of the remote database.

Server class ASEnterprise

Component Integration Services forwards the following drop index syntax to a remote server configured as class ASEnterprise:

drop index table_name.index_name

Component Integration Services precedes this statement with a use database command since the drop index syntax does not allow you to specify the database name.

Server class ASAnywhere

Component Integration Services forwards the following drop index syntax to a remote server configured as class ASAnywhere:
```
drop index table_name.index_name
```
Component Integration Services precedes this statement with a use database command since the drop index syntax does not allow you to specify the database name.

Server class ASIQ

Component Integration Services forwards the following drop index syntax to a remote server configured as class ASIQ:

drop index table_name.index_name

Component Integration Services precedes this statement with a use database command since the drop index syntax does not allow you to specify the database name.

Server class direct_connect

Component Integration Services forwards the following drop index syntax to a remote server configured as class direct_connect:

drop index table_name.index_name

Server class db2

Component Integration Services forwards the following drop index syntax to a remote server configured as class db2:

drop index index_name