To drop a remote server from the Sybase IQ system tables, first drop all remote tables defined on that server, then use the DROP SERVER statement.
You must have DBA authority to delete a remote server.
Deleting a remote server (SQL)
Connect to the host database from Interactive SQL using the jConnect driver (for JDBC connectivity).
Execute a DROP SERVER statement.
The following statement drops the server named testasiq:
DROP SERVER testasiq
For a full description of the DROP SERVER statement, see Sybase IQ Reference Manual.
