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.

Quick Links:

Go to Parameters

Go to Examples

Go to Usage

Go to Standards

Go to Permissions

Syntax

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

Parameters

(back to top)

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

(back to top)

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
```

Usage

(back to top)

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.

Standards

(back to top)

ANSI SQL–Compliance level: Transact-SQL extension.

Permissions

(back to top)

Requires the MANAGE ANY LDAP SERVER system privilege.