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

Generated by metadata Documenter on 30.9.2008 8:49:38