To display a specific domain definition, use the statement
SELECT definition
FROM domain.domains
WHERE domainname = 'NAME'
Detailed information about a domain is displayed if not only the column 'definition' is selected but also any information contained in the table 'domain.domains' is retrieved:
SELECT *
FROM domain.domains
WHERE domainname = 'NAME'
If no restriction for a certain domain name is specified, a list is displayed containing all domain definitions available for the definition of tables:
SELECT *
FROM domain.domains