drop index

Removes an index from a table in the current database.

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

Component Integration Services processes the drop index command 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 the drop index command 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 the drop index command. If trace flag 11208 is turned on, the drop index command 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.

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.

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.

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.

Component Integration Services forwards the following drop index syntax to a remote server configured as class sql_server:
```
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.

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

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