Contents Index DROP CONNECTION statement DROP PUBLICATION statement

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 
Example 
DROP EXTERNLOGIN DBA TO sybase1

Contents Index DROP CONNECTION statement DROP PUBLICATION statement