Circumstances When a Select Trigger is Activated

A query on the triggering table activates a Select trigger in these cases:

• The SELECT statement is a stand-alone SELECT statement.
• The SELECT statement occurs within a UDR called in a select list.
• The SELECT statement is a subquery in a select list.
• The SELECT statement occurs within a UDR called by EXECUTE PROCEDURE or EXECUTE FUNCTION.
• The SELECT statement selects data from a supertable in a table hierarchy. In this case the SELECT statement activates Select triggers for the supertable and all the subtables in the hierarchy.

For information on SELECT statements that do not activate a Select trigger, see Circumstances When a Select Trigger is Not Activated.