DROP DATABASE statement  DROP SERVER statement

Chapter 6: SQL Statements

DROP EXTERNLOGIN statement

Description

Drops an external login from the IQ system tables.

Syntax

DROP EXTERNLOGIN login-name 
TO remote-server

Examples

Example 1

DROP EXTERNLOGIN dba TO sybase1

Usage

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

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.


Side effects

Automatic commit.

Standards

Permissions

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

See also

CREATE EXTERNLOGIN statement




Copyright © 2004. Sybase Inc. All rights reserved. DROP SERVER statement

View this document as PDF