Use of the system table DOMAIN.DOMAINCONSTRAINTS
You can use the demo data for the SQL tutorial. Start the Database Studio as database administrator MONA with the password RED and log on to demo database DEMODB: Logging On to a Database.
Create domains. Proceed as described in SQL Tutorial, Domains.
You can use Database Studio to enter and execute SQL statements. More information: Working with SQL Statements: Overview
Note the General Instructions for formulating SQL statements.
You can use the system table DOMAINCONSTRAINTS to determine the following database information, among other things:
All domains for which a constraint on the permissible values was defined and the definition of this domain
SELECT domainname, definition
FROM DOMAIN.DOMAINCONSTRAINTS
All domains of the database user MONA for which a constraint on the permissible values was defined
SELECT owner, domainname
FROM DOMAIN.DOMAINCONSTRAINTS
WHERE owner = 'MONA'
All domains: see DOMAINS