> ## Documentation Index
> Fetch the complete documentation index at: https://cockroachlabs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.
# SHOW CONSTRAINTS
export const InternalLink = ({version, path = "", children, ...props}) => {
let detectedVersion = version || "stable";
if (typeof window !== 'undefined' && !version) {
const match = window.location.pathname.match(/\/docs\/([^/]+)/);
if (match) {
detectedVersion = match[1];
}
}
const normalizedPath = path.startsWith("/") ? path.slice(1) : path;
return
{children}
;
};
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
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> 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)
);
```
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SHOW CONSTRAINTS FROM orders;
```
```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
+------------+------------------------+-----------------+--------------------------------------------------------------------------+-----------+
| 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 CONSTRAINT`
* `RENAME CONSTRAINT`
* `DROP CONSTRAINT`
* `VALIDATE CONSTRAINT`
* `CREATE TABLE`
* Information Schema
* SQL Statements