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 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Supported by Open Client/Open Server.

Example 

DROP SERVER ase_prod

SQL Anywhere Studio 9.0.1
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.