drop index

Component Integration Services includes changes to the drop index command.

When the server receives the drop index command, it passes the command to an appropriate access method, if the object on which the command is to operate has been associated with a remote or external storage location.

drop index is reconstructed using a syntax appropriate for the class and is passed to the remote server for execution.

This command is passed to remote servers as a language request.

See also drop index in the Reference Manual: Procedures

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