SHOW DOMAINS

From InterBase

Go Up to isql Command Reference


Lists all domains or displays information about a specified domain.

SHOW {DOMAINS | DOMAIN name};
Argument Description

<name>

Name of an existing domain in the current database

Options: To see a list of existing domains, use SHOW DOMAINS without specifying a domain name. SHOW DOMAIN name displays information about the named domain in the current database. Output includes a domain’s data type, default value, and any CHECK constraints defined. Only user-defined metadata is displayed.

Example: The following example lists all domains and then shows the definition of the domain, SALARY:

SHOW DOMAINS;
FIRSTNAME LASTNAME
PHONENUMBER COUNTRYNAME
ADDRESSLINE EMPNO
DEPTNO PROJNO
CUSTNO JOBCODE
JOBGRADE SALARY
BUDGET PRODTYPE
PONUMBER

SHOW DOMAIN SALARY;
SALARY NUMERIC(15, 2) Nullable
DEFAULT 0
CHECK (VALUE > 0)