Drops an external login from the Sybase IQ system tables.
DROP EXTERNLOGIN login-name TO remote-server
DROP EXTERNLOGIN dba TO sybase1
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—Specifies the name of the remote server. The alternate login name of the local user and password for that server is the external login that is deleted.
SQL—ISO/ANSI SQL compliant.
Sybase—Supported by Open Client/Open Server.
Must have DBA or USER ADMIN authority.