Entering content frame

This graphic is explained in the accompanying text DOMAINCONSTRAINTS Locate the document in the library structure

Prerequisites

You have generated the Structure linkdemo data for the SQL Tutorial.

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

Create domains. Proceed as described in SQL Tutorial, Structure linkDomains.

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'

Note

All domains: see DOMAINS

 

Leaving content frame