Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Statements : DROP DOMAIN
 

DROP DOMAIN

Using the drop domain, you can delete a security domain.

Syntax

DROP DOMAIN domain_name;

Parameters

domain_name
Specifies the name of the security domain.
Note: To drop a domain, you must first drop all the users associated with the domain.

Note

Each database contains tenants, users, and domains. A DBA must complete the steps specified below to drop a tenant from the database:
1. DROP USER for every user in the domain. For more information on dropping a user.
2. DROP DOMAIN for every domain defined for the tenant.
3. DROP TENANT.

Example

The syntax shown below shows how to drop a domain.
DROP DOMAIN jasper;
* Authorization
* Related Statement