DOMAINCONSTRAINTS

Prerequisites

You have generated the demo data for the SQL Tutorial.

Log on to the demo database instance DEMODB as user MONA.

Create domains. Proceed as described in SQL Tutorial, Domains.

Examples

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