drop table

Removes a table definition and all of its data, indexes, triggers, and permissions from the database.

drop table [[database.]owner.]table_name 
 [, [[database.]owner.]table_name ]...

Component Integration Services processes the drop table command when the table on which it operates has been created as a proxy table. Component Integration Services forwards the entire request (or part of it) to the server that owns the actual object if the table was not created with the existing keyword.
When Component Integration Services forwards the drop table command to a remote server, the table name used is the remote table name. This name may not be the same as the local proxy table name.
If multiple tables are dropped in a single command, each table is sent as an individual drop table command.
A table in use by another user or process cannot be dropped and an error stating that the table is in use is returned.

Component Integration Services forwards the following drop table syntax to a remote server configured as class ASEnterprise:
```
drop table database.owner.table_name
```

Component Integration Services forwards the following drop table syntax to a remote server configured as class ASAnywhere:
```
drop table database.owner.table_name
```

Component Integration Services forwards the following drop table syntax to a remote server configured as class ASIQ:
```
drop table database.owner.table_name
```

Component Integration Services forwards the following drop table syntax to a remote server configured as class sql_server:
```
drop table database.owner.table_name
```

Component Integration Services requests a capabilities response from a remote server with server class direct_connect, but support for drop table is not optional. The behavior of the DirectConnect is database dependent.

Component Integration Services forwards the following drop table syntax to a remote server configured as class db2:
```
drop table owner.table_name
```