> ## 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 TRIGGERS
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 TRIGGERS` statement lists the triggers defined on a table.
## Required privileges
The user must have any privilege on the target table.
## Synopsis
## 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
* `CREATE TRIGGER`
* `DROP TRIGGER`
* `SHOW CREATE`
* SQL Statements