Removes one or more databases from Adaptive Server.
drop database database_name [, database_name]...
For each database being dropped, Component Integration Services scans sysobjects to check for proxy tables in the database. Each proxy table that was not created with the existing keyword, with create_proxy_table, or with create proxy database is dropped in the remote server that owns the object.
drop database in the Reference Manual