Reference Manual
   CHAPTER 9. SQL Statements     

DROP SERVER statement

Function 

To drop a remote server from the Adaptive Server Anywhere catalogs.

Syntax 

DROP SERVER server-name

Permissions 

Only the DBA account can delete a remote server.

Not supported on Windows CE.

Side effects 

Automatic commit.

See also 

CREATE SERVER statement

Description 

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.

Standards and compatibility 

• SQL/92 Entry-level feature.

• Sybase Supported by Open Client/Open Server.

Example 

DROP SERVER ase_prod