Reference Manual
   CHAPTER 9. SQL Statements     

DROP EXTERNLOGIN statement

Function 

To drop an external login from the Adaptive Server Anywhere catalogs.

Syntax 

DROP EXTERNLOGIN login-name
TO remote-server

Permissions 

Only the login-name and the DBA account can delete an external login for login-name.

Side effects 

Automatic commit.

See also 

CREATE EXTERNLOGIN statement

Description 

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

login-name     specifies the local user login name

TO clause     The 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.

Standards and compatibility 

• SQL/92 Entry-level feature.

• Sybase Supported by Open Client/Open Server.

Example 

DROP EXTERNLOGIN dba TO sybase1