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 2008, 2012, 2014, and 2016 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 © 2017 erwin Inc.
All rights reserved.
|
|