drop index

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

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

Usage

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