Reference Manual
   CHAPTER 9. SQL Statements     

CREATE TRIGGER statement [T-SQL]

Function 

To create a new procedure in the database in a manner compatible with Adaptive Server Enterprise.

Syntax 1 

CREATE TRIGGER [owner.]trigger_name
... ON [owner.]table_name
... FOR { INSERT , UPDATE , DELETE }
... AS
... statement-list

Syntax 2 

CREATE TRIGGER [owner.]trigger_name
... ON [owner.]table_name
... FOR {INSERT , UPDATE}
... AS
... [ IF UPDATE ( column_name )
... [ { AND | OR} UPDATE ( column_name ) ] ... ]
... statement-list
... [ IF UPDATE ( column_name )
... [ { AND | OR} UPDATE ( column_name ) ] ... ]
... statement-list

Description 

• The rows deleted or inserted are held in two declared temporary tables given the default names deleted, and inserted, as in Adaptive Server Enterprise.

• In Adaptive Server Enterprise, trigger names must be unique in the database. In Adaptive Server Anywhere, trigger names must be unique for a given owner. For compatible databases, you should make trigger names unique in the database.

• Transact-SQL triggers are executed after the triggering statement.

Standards and compatibility 

• SQL/92     Transact-SQL extension.

• Sybase     Anywhere supports a subset of the Adaptive Server Enterprise syntax.