> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cockroachlabs.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SHOW TRIGGERS

The `SHOW TRIGGERS` [statement](https://docs.cockroachlabs.com/docs/stable/sql-statements.md) lists the [triggers](https://docs.cockroachlabs.com/docs/stable/triggers.md) defined on a table.

## Required privileges

The user must have any [privilege](https://docs.cockroachlabs.com/docs/stable/security-reference/authorization.md#managing-privileges) on the target table.

## Synopsis

![show\_triggers syntax diagram](https://mintcdn.com/cockroachlabs/UZNSFbmU2EwEm6G5/images/sql-diagrams/common/show_triggers.svg?fit=max\&auto=format\&n=UZNSFbmU2EwEm6G5\&q=85\&s=1937663461d641785784b944c18fd3bc)

## Parameters

| Parameter | Description |
| - | - |
| `table_name` | The name of the table for which to list triggers. |

## Response

| Field | Description |
| - | - |
| `trigger_name` | The name of the trigger. |
| `enabled` | Whether the trigger is enabled. |

## Example

Create a sample table and trigger:

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
CREATE TABLE users (id INT PRIMARY KEY, name STRING);
```

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
CREATE FUNCTION update_timestamp()
RETURNS TRIGGER AS $$
BEGIN
  RAISE NOTICE 'Current timestamp: %', now();
  RETURN NEW;
END;
$$ LANGUAGE PLpgSQL;
```

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
CREATE TRIGGER log_update_timestamp
AFTER UPDATE ON users
FOR EACH ROW
EXECUTE FUNCTION update_timestamp();
```

List the triggers on the table:

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
SHOW TRIGGERS FROM users;
```

```
      trigger_name     | enabled
-----------------------+----------
  log_update_timestamp |    t
(1 row)
```

## See also

* [Triggers](https://docs.cockroachlabs.com/docs/stable/triggers.md)
* [`CREATE TRIGGER`](https://docs.cockroachlabs.com/docs/stable/create-trigger)
* [`ALTER TRIGGER`](https://docs.cockroachlabs.com/docs/stable/alter-trigger)
* [`DROP TRIGGER`](https://docs.cockroachlabs.com/docs/stable/drop-trigger)
* [`SHOW CREATE`](https://docs.cockroachlabs.com/docs/stable/show-create)
* [SQL Statements](https://docs.cockroachlabs.com/docs/stable/sql-statements.md)