On this page 
The SHOW CONSTRAINTS statement lists all named constraints as well as any unnamed CHECK constraints on a table.
Required privileges
The user must have any privilege on the target table.
Aliases
SHOW CONSTRAINT is an alias for SHOW CONSTRAINTS.
Synopsis
Parameters
| Parameter | Description |
|---|---|
table_name |
The name of the table for which to show constraints. |
Response
The following fields are returned for each constraint.
| Field | Description |
|---|---|
table_name |
The name of the table. |
constraint_name |
The name of the constraint. |
constraint_type |
The type of constraint. |
details |
The definition of the constraint, including the column(s) to which it applies. |
validated |
Whether values in the column(s) match the constraint. |
Example
> CREATE TABLE orders (
id INT PRIMARY KEY,
date TIMESTAMP NOT NULL,
priority INT DEFAULT 1,
customer_id INT UNIQUE,
status STRING DEFAULT 'open',
CHECK (priority BETWEEN 1 AND 5),
CHECK (status in ('open', 'in progress', 'done', 'cancelled')),
FAMILY (id, date, priority, customer_id, status)
);
> SHOW CONSTRAINTS FROM orders;
+------------+------------------------+-----------------+--------------------------------------------------------------------------+-----------+
| table_name | constraint_name | constraint_type | details | validated |
+------------+------------------------+-----------------+--------------------------------------------------------------------------+-----------+
| orders | check_priority | CHECK | CHECK (priority BETWEEN 1 AND 5) | true |
| orders | check_status | CHECK | CHECK (status IN ('open':::STRING, 'in progress':::STRING, | true |
| | | | 'done':::STRING, 'cancelled':::STRING)) | |
| orders | orders_customer_id_key | UNIQUE | UNIQUE (customer_id ASC) | true |
| orders | primary | PRIMARY KEY | PRIMARY KEY (id ASC) | true |
+------------+------------------------+-----------------+--------------------------------------------------------------------------+-----------+
(4 rows)
See also
- Constraints
ADD CONSTRAINTRENAME CONSTRAINTDROP CONSTRAINTVALIDATE CONSTRAINTCREATE TABLE- Information Schema
- SQL Statements
Was this helpful?
