ASA SQL Reference
SQL Statements
Use this statement to drop a remote server from the Adaptive Server Anywhere catalog.
DROP SERVER server-name
DROP SERVER deletes a remote server from the Adaptive Server Anywhere catalogs. You must drop all the proxy tables that have been defined for the remote server before this statement will succeed.
Only the DBA account can delete a remote server.
Not supported on Windows CE.
Automatic commit.
SQL/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Supported by Open Client/Open Server.
DROP SERVER ase_prod