ASA SQL Reference

SQL Statements

DROP EXTERNLOGIN statement

Description 

Use this statement to drop an external login from the Adaptive Server Anywhere catalogs.

Syntax 

DROP EXTERNLOGIN login-name TO remote-server

Parameters 

DROP clause    Specifies the local user login name

TO clause    Specifies the name of the remote server. The local user's alternate login name and password for that server is the external login that is deleted.

Usage 

DROP EXTERNLOGIN deletes an external login from the Adaptive Server Anywhere catalogs.

Permissions 

Must be the owner of login-name or have DBA authority.

Side effects 

Automatic commit.

See also 

• CREATE EXTERNLOGIN statement

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Supported by Open Client/Open Server.

Example 

DROP EXTERNLOGIN DBA TO sybase1

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