> ## 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.
# ALTER TRIGGER
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 `ALTER TRIGGER` statement modifies a trigger.
## Required privileges
To rename a trigger, the user must be the owner of the table on which the trigger is defined.
## Synopsis
## Parameters
| Parameter | Description |
| ------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------- |
| `IF EXISTS` | Rename the trigger only if the table and trigger exist. If the table or trigger does not exist, the statement succeeds without renaming a trigger. |
| `trigger_name` | The current name of the trigger. |
| `table_name` | The name of the table associated with the trigger. |
| `trigger_new_name` | The new name of the trigger. |
`ALTER TRIGGER ... IF EXISTS` is a CockroachDB extension of the PostgreSQL syntax, which does not accept `IF EXISTS` for `ALTER TRIGGER`.
Renaming a trigger to its current name succeeds without changes. Renaming a trigger to a name that is already used by another trigger on the same table returns a duplicate-object error.
## Examples
#### Setup
To follow along, run `cockroach demo` to start a temporary, in-memory cluster with the `movr` sample dataset preloaded:
```shell theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
$ cockroach demo
```
### Rename a trigger
Create a sample trigger function:
```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;
```
Create a sample trigger:
```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();
```
Rename the trigger:
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
ALTER TRIGGER log_update_timestamp ON users RENAME TO log_updates;
```
Verify the new trigger name:
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
SHOW TRIGGERS FROM users;
```
```
trigger_name | enabled
---------------+----------
log_updates | t
(1 row)
```
## See also
* Triggers
* `CREATE TRIGGER`
* `DROP TRIGGER`
* `SHOW TRIGGERS`
* `SHOW CREATE`
* `CREATE FUNCTION`