Try OpenEdge Now
skip to main content
SQL Development
OpenEdge SQL Data Definition Language : Using Data Definition Language statements : Working with domains : DROP DOMAIN
 
DROP DOMAIN
Using the drop domain, you can delete a security domain.To drop a domain, you must have DBA privileges.
Syntax
DROP DOMAIN domain_name;
Note: To drop a domain, you must first drop all the users associated with the domain.
Example: DROP DOMAIN statement
DROP DOMAIN jasper;
For more on the DROP DOMAIN statement, see OpenEdge Data Management: SQL Reference.
Notes
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.
2. DROP DOMAIN for every domain defined for the tenant.
3. DROP TENANT.