A trigger is a stored procedure that executes in response to an event. For example, a trigger can be executed when a row in a table is inserted, updated, or deleted. The trigger tells the DBMS how to process the SQL INSERT, UPDATE, or DELETE commands to enforce business rules. This product supports four categories of triggers in SQL Server 2005 and 2008 physical models:
Define all the triggers that exist for the selected database.
Define all the triggers that exist for the selected server.
Define all the triggers that exist for the selected table.
Define all the triggers that exist for the selected view.
|
Copyright © 2013 CA.
All rights reserved.
|
|