DROP LOGICAL SERVER Statement

Drops a user-defined logical server.

Syntax

DROP LOGICAL SERVER logical-server-name

Examples

  • Example 1 – This example drops a user-defined logical server ls1.
    DROP LOGICAL SERVER ls1

Usage

Sybase IQ performs the following catalog changes internally when dropping a logical server:

  • Drops all membership definitions of the logical server.

  • Drops its logical server assignment from each login policy that has an explicit assignment to the subject logical server. If it is the only logical server assigned to the login policy, Sybase IQ sets the logical server assignment for the login policy to NONE.

  • Removes the logical server entry from ISYSIQ.LOGICALSERVER.

Permissions

Must have DBA or MULTIPLEX ADMIN authority.

Parent topic: SQL Statements