A trigger can be created on which of the following objects?
-
View
-
Catalog Table
-
Stored Procedure
-
Global Temprory Table
A
Correct answer
Explanation
INSTEAD OF triggers can be created on views to intercept insert, update, or delete operations against the view and redirect them to the underlying base tables. Triggers cannot be created on catalog tables, stored procedures, or global temporary tables.