DROP EXTERNLOGIN statement

Description

Drops an external login from the Sybase IQ system tables.

Syntax

DROP EXTERNLOGIN login-name 
TO remote-server 

Examples

Example 1

DROP EXTERNLOGIN dba TO sybase1

Usage

Changes made by DROP EXTERNLOGIN do not take effect until the next connection to the remote server.

DROP EXTERNLOGIN deletes an external login from the Sybase IQ system tables.

login-name Specifies the local user login name.

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


Side effects

Automatic commit.

Standards

Permissions

Must have DBA or USER ADMIN authority.

See also

CREATE EXTERNLOGIN statement