List of triggers

CollapseAll image

Collapse image Triggers


Name  Schema  Description Instead of  For 
insert
For 
update
For 
delete
Table/view
[tr_d_AUDIT_AWBuildVersion] dbo         For Delete [dbo].[AWBuildVersion]
[tr_d_AUDIT_DatabaseLog] dbo         For Delete [dbo].[DatabaseLog]
[tr_d_AUDIT_ErrorLog] dbo         For Delete [dbo].[ErrorLog]
[tr_i_AUDIT_DatabaseLog] dbo     For Insert     [dbo].[DatabaseLog]
[tr_i_AUDIT_ErrorLog] dbo     For Insert     [dbo].[ErrorLog]
[tr_u_AUDIT_AWBuildVersion] dbo       For Update   [dbo].[AWBuildVersion]
[tr_u_AUDIT_DatabaseLog] dbo       For Update   [dbo].[DatabaseLog]
[dEmployee] HumanResources       For Delete [HumanResources].[Employee]
[tr_d_AUDIT_Department] HumanResources         For Delete [HumanResources].[Department]
[tr_d_AUDIT_Employee] HumanResources         For Delete [HumanResources].[Employee]
[tr_d_AUDIT_EmployeeDepartmentHistory] HumanResources         For Delete [HumanResources].[EmployeeDepartmentHistory]
[tr_d_AUDIT_EmployeePayHistory] HumanResources         For Delete [HumanResources].[EmployeePayHistory]
[tr_i_AUDIT_Department] HumanResources     For Insert     [HumanResources].[Department]
[tr_i_AUDIT_Employee] HumanResources     For Insert     [HumanResources].[Employee]
[tr_i_AUDIT_EmployeeDepartmentHistory] HumanResources     For Insert     [HumanResources].[EmployeeDepartmentHistory]
[tr_i_AUDIT_EmployeePayHistory] HumanResources     For Insert     [HumanResources].[EmployeePayHistory]
[tr_u_AUDIT_Department] HumanResources       For Update   [HumanResources].[Department]
[tr_u_AUDIT_Employee_Temporal] HumanResources       For Update   [HumanResources].[Employee_Temporal]
[tr_u_AUDIT_EmployeeDepartmentHistory] HumanResources       For Update   [HumanResources].[EmployeeDepartmentHistory]
[tr_u_AUDIT_EmployeePayHistory] HumanResources       For Update   [HumanResources].[EmployeePayHistory]
[iuPerson] Person     For Insert For Update   [Person].[Person]
[iWorkOrder] Production     For Insert     [Production].[WorkOrder]
[uWorkOrder] Production       For Update   [Production].[WorkOrder]
[dVendor] Purchasing       For Delete [Purchasing].[Vendor]
[iPurchaseOrderDetail] Purchasing     For Insert     [Purchasing].[PurchaseOrderDetail]
[uPurchaseOrderDetail] Purchasing       For Update   [Purchasing].[PurchaseOrderDetail]
[uPurchaseOrderHeader] Purchasing       For Update   [Purchasing].[PurchaseOrderHeader]
[iduSalesOrderDetail] Sales     For Insert For Update For Delete [Sales].[SalesOrderDetail]
[uSalesOrderHeader] Sales       For Update   [Sales].[SalesOrderHeader]
Total: 29  trigger(s)

Collapse image See also


Tables

Views

Database overview