CREATE TRIGGER (Transact-SQL) [!INCLUDE SQL Server SQL Database] Creates a DML, DDL, or logon trigger. A trigger is a special type of stored procedure that automatically runs when an event occurs in ...
When you rename a trigger, the trigger must be in the current database, and the new name must follow the rules for [identifiers](../databases/database-identifiers.md).