SHOW CHECK
From InterBase
Go Up to isql Command Reference
Displays all CHECK constraints defined for a specified table.
SHOW CHECK table;
| Argument | Description |
|---|---|
|
<table> |
Name of an existing table in the current database |
Description: SHOW CHECK displays CHECK constraints for a named table in the current database. Only user-defined metadata is displayed. To see a list of existing tables, use SHOW TABLE.
Example: The following example shows CHECK constraints defined for the JOB table. The SHOW TABLES command is used first to display a list of available tables.
SHOW TABLES;
COUNTRY CUSTOMER
DEPARTMENT EMPLOYEE
EMPLOYEE_PROJECT JOB
PHONE_LIST PROJECT
PROJ_DEPT_BUDGET SALARY_HISTORY
SALES
SHOW CHECK JOB;
CHECK (min_salary < max_salary)