List of table/view triggers

Table/view triggers

Name	Owner	Disabled	Instead Of	Table/View	Description
dEmployee	HumanResources			HumanResources.Employee	INSTEAD OF DELETE trigger which keeps Employees from being deleted.
dVendor	Purchasing			Purchasing.Vendor	INSTEAD OF DELETE trigger which keeps Vendors from being deleted.
iduSalesOrderDetail	Sales			Sales.SalesOrderDetail	AFTER INSERT, DELETE, UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in SalesOrderDetail and updates the SalesOrderHeader.SubTotal column.
iPurchaseOrderDetail	Purchasing			Purchasing.PurchaseOrderDetail	AFTER INSERT trigger that inserts a row in the TransactionHistory table and updates the PurchaseOrderHeader.SubTotal column.
iStore	Sales			Sales.Store	AFTER INSERT trigger inserting Store only if the Customer does not exist in the Individual table.
iuIndividual	Sales			Sales.Individual	AFTER INSERT, UPDATE trigger inserting Individual only if the Customer does not exist in the Store table and setting the ModifiedDate column in the Individual table to the current date.
iWorkOrder	Production			Production.WorkOrder	AFTER INSERT trigger that inserts a row in the TransactionHistory table.
uPurchaseOrderDetail	Purchasing			Purchasing.PurchaseOrderDetail	AFTER UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in PurchaseOrderDetail and updates the PurchaseOrderHeader.SubTotal column.
uPurchaseOrderHeader	Purchasing			Purchasing.PurchaseOrderHeader	AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the PurchaseOrderHeader table.
uSalesOrderHeader	Sales			Sales.SalesOrderHeader	AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the SalesOrderHeader table.Updates the SalesYTD column in the SalesPerson and SalesTerritory tables.
uWorkOrder	Production			Production.WorkOrder	AFTER UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in the WorkOrder table.

Total: 11 trigger(s)