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)