Renames an existing trigger on a given table.

Syntax

---

RENAME TRIGGER <Name> ON <TableName>
TO <Name>

Usage

---

Use this statement to rename a trigger on a table.

Examples

---

-- The following statement renames the UpdateNotes
-- trigger to UpdNotes.

RENAME TRIGGER "UpdateNotes" ON "Customer"
TO "UpdNotes"

Required Privileges

---

The current user must be granted the ALTER privilege on the specified table in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations

---

This statement deviates from the SQL 2003 standard in the following ways: