|
Trigger |
Schema |
For Object |
Is Instead Of |
Insert Trigger |
Update Trigger |
Delete Trigger |
Description |
|
iup_t200_trg
|
dbo
|
[dbo].[t200] |
|
|
|
|
|
|
trg_ins_t1
|
dbo
|
[dbo].[t1] |
|
|
|
|
|
|
uMobiEmployeeTrg
|
dbo
|
[dbo].[vMobiEmployee] |
|
|
|
|
mobi czwartek uMobiEmployeeTrg |
|
dEmployee
|
HumanResources
|
[HumanResources].[Employee] |
|
|
|
|
INSTEAD OF DELETE trigger which keeps Employees from being deleted. |
|
iuPerson
|
Person
|
[Person].[Person] |
|
|
|
|
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 |
|
iWorkOrder
|
Production
|
[Production].[WorkOrder] |
|
|
|
|
AFTER INSERT trigger that inserts a row in the TransactionHistory table. mobi |
|
uWorkOrder
|
Production
|
[Production].[WorkOrder] |
|
|
|
|
AFTER UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in the WorkOrder table. mobi |
|
dVendor
|
Purchasing
|
[Purchasing].[Vendor] |
|
|
|
|
INSTEAD OF DELETE trigger which keeps Vendors from being deleted. |
|
iPurchaseOrderDetail
|
Purchasing
|
[Purchasing].[PurchaseOrderDetail] |
|
|
|
|
AFTER INSERT trigger that inserts a row in the TransactionHistory table and updates the PurchaseOrderHeader.SubTotal column. |
|
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. |
|
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. |
|
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. |