DROP LDAP SERVER Statement

Removes the named LDAP server configuration object from the SYSLDAPSERVER system view after verifying that the LDAP server configuration object is not in a READY or ACTIVE state.

The DROP LDAP SERVER statement fails when it is issued against an LDAP server configuration object that is in a READY or ACTIVE state. This ensures that an LDAP server configuration object in active use cannot be accidentally dropped. The DROP LDAP SERVER statement also fails if a login policy exists with a reference to the LDAP server configuration object.

Syntax

DROP LDAP SERVER <ldapua-server-name>
[ WITH DROP ALL REFERENCES ] [ WITH SUSPEND ]

Parameters

WITH DROP ALL REFERENCES – allows the removal of an LDAP server configuration object from service that has a reference in a login policy.
WITH SUSPEND – allows an LDAP server configuration object to be dropped even if in a READY or ACTIVE state.

Examples

Example 1 – assuming that references to the LDAP server configuration object have been removed from all login policies, the following two sets of commands are equivalent. Using the WITH DROP ALL REFERENCES and WITH SUSPEND parameters eliminates the need to execute an ALTER LDAP SERVER statement before the DROP LDAP SERVER statement:
```
DROP LDAP SERVER ldapserver1 WITH DROP ALL REFERENCES WITH SUSPEND

is equivalent to 

ALTER LDAP SERVER ldapserver1 WITH SUSPEND
DROP LDAP SERVER ldapserver1 WITH DROP ALL REFERENCES
```

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Requires the MANAGE ANY LDAP SERVER system privilege.