Drops a remote server from the Sybase IQ system tables.
DROP SERVER server-name
DROP SERVER ase_prod
You must drop all the proxy tables that have been defined for the remote server before this statement succeeds.
Automatic commit.
Only the DBA account can delete a remote server.