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. |
See Also
Database overview