On this page
Warning:
As of November 10, 2018, CockroachDB v1.0 is no longer supported. For more details, refer to the Release Support Policy.
The SHOW CONSTRAINTS
statement lists all named constraints as well as any unnamed Check constraints on a table.
Warning:
The SHOW CONSTRAINTS
statement is under development; the exact output will continue to change.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.
Warning:
The SHOW CONSTRAINTS
statement is under development; the exact output will continue to change.Field | Description |
---|---|
Table |
The name of the table. |
Name |
The name of the constraint. |
Type |
The type of constraint. |
Column(s) |
The columns to which the constraint applies. For Check constraints, column information will be in Details and this field will be NULL . |
Details |
The conditions for a Check 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 | Type | Column(s) | Details |
+--------+------------------------+-------------+---------------+--------------------------------------------------------+
| orders | | CHECK | NULL | status IN ('open', 'in progress', 'done', 'cancelled') |
| orders | | CHECK | NULL | priority BETWEEN 1 AND 5 |
| orders | orders_customer_id_key | UNIQUE | [customer_id] | NULL |
| orders | primary | PRIMARY KEY | [id] | NULL |
+--------+------------------------+-------------+---------------+--------------------------------------------------------+
(4 rows)