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

• CREATE SERVER statement

Standards and compatibility

Example

DROP SERVER ase_prod;