Home / AdventureWorks Database

Triggers

Name	Activates on	Instead Of	For Replication	Enabled	Created	Modified	Table
dEmployee	DELETE				14.10.2005. 1:59:52	14.10.2005. 1:59:52	HumanResources.Employee
dVendor	DELETE				14.10.2005. 1:59:57	2.7.2009. 10:35:10	Purchasing.Vendor
iduSalesOrderDetail	INSERT, UPDATE, DELETE				14.10.2005. 1:59:55	2.7.2009. 10:35:10	Sales.SalesOrderDetail
iPurchaseOrderDetail	INSERT				14.10.2005. 1:59:54	2.7.2009. 10:35:10	Purchasing.PurchaseOrderDetail
iStore	INSERT				14.10.2005. 1:59:56	2.7.2009. 10:35:10	Sales.Store
iuIndividual	INSERT, UPDATE				14.10.2005. 1:59:52	2.7.2009. 10:35:10	Sales.Individual
iWorkOrder	INSERT				14.10.2005. 1:59:57	2.7.2009. 10:35:10	Production.WorkOrder
uAddress	UPDATE				14.10.2005. 1:59:50	2.7.2009. 10:35:10	Person.Address
uAddressType	UPDATE				14.10.2005. 1:59:50	2.7.2009. 10:35:10	Person.AddressType
uAWBuildVersion	UPDATE				14.10.2005. 1:59:50	2.7.2009. 10:35:10	dbo.AWBuildVersion
uBillOfMaterials	UPDATE				14.10.2005. 1:59:50	2.7.2009. 10:35:10	Production.BillOfMaterials
uContact	UPDATE				14.10.2005. 1:59:50	2.7.2009. 10:35:10	Person.Contact
uContactCreditCard	UPDATE				14.10.2005. 1:59:50	2.7.2009. 10:35:10	Sales.ContactCreditCard
uContactType	UPDATE				14.10.2005. 1:59:50	2.7.2009. 10:35:10	Person.ContactType
uCountryRegion	UPDATE				14.10.2005. 1:59:51	2.7.2009. 10:35:10	Person.CountryRegion
uCountryRegionCurrency	UPDATE				14.10.2005. 1:59:51	2.7.2009. 10:35:10	Sales.CountryRegionCurrency
uCreditCard	UPDATE				14.10.2005. 1:59:51	2.7.2009. 10:35:10	Sales.CreditCard
uCulture	UPDATE				14.10.2005. 1:59:51	2.7.2009. 10:35:10	Production.Culture
uCurrency	UPDATE				14.10.2005. 1:59:51	2.7.2009. 10:35:10	Sales.Currency
uCurrencyRate	UPDATE				14.10.2005. 1:59:51	2.7.2009. 10:35:10	Sales.CurrencyRate
uCustomer	UPDATE				14.10.2005. 1:59:51	2.7.2009. 10:35:10	Sales.Customer
uCustomerAddress	UPDATE				14.10.2005. 1:59:51	2.7.2009. 10:35:10	Sales.CustomerAddress
uDepartment	UPDATE				14.10.2005. 1:59:51	2.7.2009. 10:35:10	HumanResources.Department
uDocument	UPDATE				14.10.2005. 1:59:52	2.7.2009. 10:35:10	Production.Document
uEmployee	UPDATE				14.10.2005. 1:59:52	2.7.2009. 10:35:10	HumanResources.Employee
uEmployeeAddress	UPDATE				14.10.2005. 1:59:52	2.7.2009. 10:35:10	HumanResources.EmployeeAddress
uEmployeeDepartmentHistory	UPDATE				14.10.2005. 1:59:52	2.7.2009. 10:35:10	HumanResources.EmployeeDepartmentHistory
uEmployeePayHistory	UPDATE				14.10.2005. 1:59:52	2.7.2009. 10:35:10	HumanResources.EmployeePayHistory
uIllustration	UPDATE				14.10.2005. 1:59:52	2.7.2009. 10:35:10	Production.Illustration
uJobCandidate	UPDATE				14.10.2005. 1:59:52	2.7.2009. 10:35:10	HumanResources.JobCandidate
uLocation	UPDATE				14.10.2005. 1:59:53	2.7.2009. 10:35:10	Production.Location
uProduct	UPDATE				14.10.2005. 1:59:53	2.7.2009. 10:35:10	Production.Product
uProductCategory	UPDATE				14.10.2005. 1:59:53	2.7.2009. 10:35:10	Production.ProductCategory
uProductCostHistory	UPDATE				14.10.2005. 1:59:53	2.7.2009. 10:35:10	Production.ProductCostHistory
uProductDescription	UPDATE				14.10.2005. 1:59:53	2.7.2009. 10:35:10	Production.ProductDescription
uProductDocument	UPDATE				14.10.2005. 1:59:53	2.7.2009. 10:35:10	Production.ProductDocument
uProductInventory	UPDATE				14.10.2005. 1:59:53	2.7.2009. 10:35:10	Production.ProductInventory
uProductListPriceHistory	UPDATE				14.10.2005. 1:59:53	2.7.2009. 10:35:10	Production.ProductListPriceHistory
uProductModel	UPDATE				14.10.2005. 1:59:53	2.7.2009. 10:35:10	Production.ProductModel
uProductModelIllustration	UPDATE				14.10.2005. 1:59:54	2.7.2009. 10:35:10	Production.ProductModelIllustration
uProductModelProductDescriptionCulture	UPDATE				14.10.2005. 1:59:54	2.7.2009. 10:35:10	Production.ProductModelProductDescriptionCulture
uProductPhoto	UPDATE				14.10.2005. 1:59:54	2.7.2009. 10:35:10	Production.ProductPhoto
uProductProductPhoto	UPDATE				14.10.2005. 1:59:54	2.7.2009. 10:35:10	Production.ProductProductPhoto
uProductReview	UPDATE				14.10.2005. 1:59:54	2.7.2009. 10:35:10	Production.ProductReview
uProductSubcategory	UPDATE				14.10.2005. 1:59:54	2.7.2009. 10:35:10	Production.ProductSubcategory
uProductVendor	UPDATE				14.10.2005. 1:59:54	2.7.2009. 10:35:10	Purchasing.ProductVendor
uPurchaseOrderDetail	UPDATE				14.10.2005. 1:59:54	2.7.2009. 10:35:10	Purchasing.PurchaseOrderDetail
uPurchaseOrderHeader	UPDATE				14.10.2005. 1:59:55	2.7.2009. 10:35:10	Purchasing.PurchaseOrderHeader
uSalesOrderHeader	UPDATE				14.10.2005. 1:59:55	2.7.2009. 10:35:10	Sales.SalesOrderHeader
uSalesOrderHeaderSalesReason	UPDATE				14.10.2005. 1:59:55	2.7.2009. 10:35:10	Sales.SalesOrderHeaderSalesReason
uSalesPerson	UPDATE				14.10.2005. 1:59:55	2.7.2009. 10:35:10	Sales.SalesPerson
uSalesPersonQuotaHistory	UPDATE				14.10.2005. 1:59:55	2.7.2009. 10:35:10	Sales.SalesPersonQuotaHistory
uSalesReason	UPDATE				14.10.2005. 1:59:55	2.7.2009. 10:35:10	Sales.SalesReason
uSalesTaxRate	UPDATE				14.10.2005. 1:59:55	2.7.2009. 10:35:10	Sales.SalesTaxRate
uSalesTerritory	UPDATE				14.10.2005. 1:59:55	2.7.2009. 10:35:10	Sales.SalesTerritory
uSalesTerritoryHistory	UPDATE				14.10.2005. 1:59:56	2.7.2009. 10:35:10	Sales.SalesTerritoryHistory
uScrapReason	UPDATE				14.10.2005. 1:59:56	2.7.2009. 10:35:10	Production.ScrapReason
uShift	UPDATE				14.10.2005. 1:59:56	2.7.2009. 10:35:10	HumanResources.Shift
uShipMethod	UPDATE				14.10.2005. 1:59:56	2.7.2009. 10:35:10	Purchasing.ShipMethod
uShoppingCartItem	UPDATE				14.10.2005. 1:59:56	2.7.2009. 10:35:10	Sales.ShoppingCartItem
uSpecialOffer	UPDATE				14.10.2005. 1:59:56	2.7.2009. 10:35:10	Sales.SpecialOffer
uSpecialOfferProduct	UPDATE				14.10.2005. 1:59:56	2.7.2009. 10:35:10	Sales.SpecialOfferProduct
uStateProvince	UPDATE				14.10.2005. 1:59:56	2.7.2009. 10:35:10	Person.StateProvince
uStore	UPDATE				14.10.2005. 1:59:56	2.7.2009. 10:35:10	Sales.Store
uStoreContact	UPDATE				14.10.2005. 1:59:57	2.7.2009. 10:35:10	Sales.StoreContact
uTransactionHistory	UPDATE				14.10.2005. 1:59:57	2.7.2009. 10:35:10	Production.TransactionHistory
uTransactionHistoryArchive	UPDATE				14.10.2005. 1:59:57	2.7.2009. 10:35:10	Production.TransactionHistoryArchive
uUnitMeasure	UPDATE				14.10.2005. 1:59:57	2.7.2009. 10:35:10	Production.UnitMeasure
uVendor	UPDATE				14.10.2005. 1:59:57	2.7.2009. 10:35:10	Purchasing.Vendor
uVendorAddress	UPDATE				14.10.2005. 1:59:57	2.7.2009. 10:35:10	Purchasing.VendorAddress
uVendorContact	UPDATE				14.10.2005. 1:59:57	2.7.2009. 10:35:10	Purchasing.VendorContact
uWorkOrder	UPDATE				14.10.2005. 1:59:58	2.7.2009. 10:35:10	Production.WorkOrder
uWorkOrderRouting	UPDATE				14.10.2005. 1:59:58	2.7.2009. 10:35:10	Production.WorkOrderRouting

Generated by Spectral Core SQL Server Database Documenter on 11.7.2009. 15:05:21