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)