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)

See Also