DROP EXTERNLOGIN statement

Use this statement to drop an external login from the SQL 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.

Remarks

DROP EXTERNLOGIN deletes an external login from the SQL Anywhere catalogs.

Permissions

Must have DBA authority.

Side effects

Automatic commit.

See also
Standards and compatibility

  • SQL/2003   Vendor extension.

Example 
DROP EXTERNLOGIN DBA TO sybase1;
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1