DROP
EXTERNLOGIN Statement
Drops an external login from the SAP IQ system tables.
Syntax
DROP EXTERNLOGIN <login-name> TO <remote-server>
Parameters
- specifies the local user login name.
- 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.
Examples
- drops the login dba
from the remote database sybase1:
DROP EXTERNLOGIN dba TO sybase1
Usage
Changes made by DROP EXTERNLOGIN do not take effect until the next connection to the remote server.
Side Effects
- Automatic commit
Standards
- SQL—ISO/ANSI SQL compliant.
- SAP Database products—Supported by Open Client/Open Server.