Contents Index DROP REMOTE MESSAGE TYPE statement [SQL Remote] DROP SERVICE statement

ASA SQL Reference
  SQL Statements

DROP SERVER statement


Description 

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

Syntax 

DROP SERVER server-name

Usage 

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.

Permissions 

Only the DBA account can delete a remote server.

Not supported on Windows CE.

Side effects 

Automatic commit.

See also 

CREATE SERVER statement

Standards and compatibility 
Example 
DROP SERVER ase_prod

Contents Index DROP REMOTE MESSAGE TYPE statement [SQL Remote] DROP SERVICE statement