Drops a user-defined logical server.
DROP LOGICAL SERVER logical-server-name
DROP LOGICAL SERVER ls1
Applies to multiplex only.
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.
Must have DBA or MULTIPLEX ADMIN authority.