Default transition properties

The constraint checker automatically sets transition properties to the following default values if you use the OLD() function in the constraint SQL statement.

You can change these defaults.

Default Transition Properties

Transition Property	Default Value
Transition Table	Table of the column(s) contained in the OLD() function
Alias	Alias of this table in your SQL statement (if any)
Fire on Insert	Always
Fire on Delete	Always
Fire on Update	UsedColumns