List of Triggers

Trigger Schema For Object Is Instead Of Insert Trigger Update Trigger Delete Trigger Description
ddltrigger key icon iup_t200_trg dbo [dbo].[t200] true false true false
ddltrigger key icon trg_ins_t1 dbo [dbo].[t1] false true false false
ddltrigger key icon uMobiEmployeeTrg dbo [dbo].[vMobiEmployee] true false true false mobi czwartek uMobiEmployeeTrg
ddltrigger key icon dEmployee HumanResources [HumanResources].[Employee] true false false true INSTEAD OF DELETE trigger which keeps Employees from being deleted.
ddltrigger key icon iuPerson Person [Person].[Person] false true true false AFTER INSERT, UPDATE trigger inserting Individual only if the Customer does not exist in the Store table and setting the ModifiedDate column in the Person table to the current date. mobi czwartek
ddltrigger key icon iWorkOrder Production [Production].[WorkOrder] false true false false AFTER INSERT trigger that inserts a row in the TransactionHistory table. mobi
ddltrigger key icon uWorkOrder Production [Production].[WorkOrder] false false true false AFTER UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in the WorkOrder table. mobi
ddltrigger key icon dVendor Purchasing [Purchasing].[Vendor] true false false true INSTEAD OF DELETE trigger which keeps Vendors from being deleted.
ddltrigger key icon iPurchaseOrderDetail Purchasing [Purchasing].[PurchaseOrderDetail] false true false false AFTER INSERT trigger that inserts a row in the TransactionHistory table and updates the PurchaseOrderHeader.SubTotal column.
ddltrigger key icon uPurchaseOrderDetail Purchasing [Purchasing].[PurchaseOrderDetail] false false true false AFTER UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in PurchaseOrderDetail and updates the PurchaseOrderHeader.SubTotal column.
ddltrigger key icon uPurchaseOrderHeader Purchasing [Purchasing].[PurchaseOrderHeader] false false true false AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the PurchaseOrderHeader table.
ddltrigger key icon iduSalesOrderDetail Sales [Sales].[SalesOrderDetail] false true true true AFTER INSERT, DELETE, UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in SalesOrderDetail and updates the SalesOrderHeader.SubTotal column.
ddltrigger key icon uSalesOrderHeader Sales [Sales].[SalesOrderHeader] false false true false AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the SalesOrderHeader table.Updates the SalesYTD column in the SalesPerson and SalesTerritory tables.