DROP SERVER statement

Use this statement to drop a remote server from the SQL Anywhere catalog.

Syntax
DROP SERVER server-name
Remarks

DROP SERVER deletes a remote server from the SQL Anywhere catalogs. You must drop all the proxy tables that have been defined for the remote server before this statement will succeed.

Permissions

Only user DBA can delete a remote server.

Not supported on Windows Mobile.

Side effects

Automatic commit.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example
DROP SERVER ase_prod;