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, create_proxy_table, or create proxy database.
drop table in the Reference Manual
