Databases > AdventureWorks2019
AdventureWorks2019
Tables (71)
AWBuildVersion,
DatabaseLog,
ErrorLog,
HumanResources.Department,
HumanResources.Employee,
HumanResources.EmployeeDepartmentHistory,
HumanResources.EmployeePayHistory,
HumanResources.JobCandidate,
HumanResources.Shift,
Person.Address,
Person.AddressType,
Person.BusinessEntity,
Person.BusinessEntityAddress,
Person.BusinessEntityContact,
Person.ContactType,
Person.CountryRegion,
Person.EmailAddress,
Person.Password,
Person.Person,
Person.PersonPhone,
Person.PhoneNumberType,
Person.StateProvince,
Production.BillOfMaterials,
Production.Culture,
Production.Document,
Production.Illustration,
Production.Location,
Production.Product,
Production.ProductCategory,
Production.ProductCostHistory,
Production.ProductDescription,
Production.ProductDocument,
Production.ProductInventory,
Production.ProductListPriceHistory,
Production.ProductModel,
Production.ProductModelIllustration,
Production.ProductModelProductDescriptionCulture,
Production.ProductPhoto,
Production.ProductProductPhoto,
Production.ProductReview,
Production.ProductSubcategory,
Production.ScrapReason,
Production.TransactionHistory,
Production.TransactionHistoryArchive,
Production.UnitMeasure,
Production.WorkOrder,
Production.WorkOrderRouting,
Purchasing.ProductVendor,
Purchasing.PurchaseOrderDetail,
Purchasing.PurchaseOrderHeader,
Purchasing.ShipMethod,
Purchasing.Vendor,
Sales.CountryRegionCurrency,
Sales.CreditCard,
Sales.Currency,
Sales.CurrencyRate,
Sales.Customer,
Sales.PersonCreditCard,
Sales.SalesOrderDetail,
Sales.SalesOrderHeader,
Sales.SalesOrderHeaderSalesReason,
Sales.SalesPerson,
Sales.SalesPersonQuotaHistory,
Sales.SalesReason,
Sales.SalesTaxRate,
Sales.SalesTerritory,
Sales.SalesTerritoryHistory,
Sales.ShoppingCartItem,
Sales.SpecialOffer,
Sales.SpecialOfferProduct,
Sales.Store
Views (20)
HumanResources.vEmployee,
HumanResources.vEmployeeDepartment,
HumanResources.vEmployeeDepartmentHistory,
HumanResources.vJobCandidate,
HumanResources.vJobCandidateEducation,
HumanResources.vJobCandidateEmployment,
Person.vAdditionalContactInfo,
Person.vStateProvinceCountryRegion,
Person.vStateProvinceCountryRegion,
Production.vProductAndDescription,
Production.vProductAndDescription,
Production.vProductModelCatalogDescription,
Production.vProductModelInstructions,
Purchasing.vVendorWithAddresses,
Purchasing.vVendorWithContacts,
Sales.vIndividualCustomer,
Sales.vPersonDemographics,
Sales.vSalesPerson,
Sales.vSalesPersonSalesByFiscalYears,
Sales.vStoreWithAddresses,
Sales.vStoreWithContacts,
Sales.vStoreWithDemographics
Stored Procedures (10)
uspGetBillOfMaterials,
uspGetEmployeeManagers,
uspGetManagerEmployees,
uspGetWhereUsedProductID,
uspLogError,
uspPrintError,
uspSearchCandidateResumes,
HumanResources.uspUpdateEmployeeHireInfo,
HumanResources.uspUpdateEmployeeLogin,
HumanResources.uspUpdateEmployeePersonalInfo
Scalar Functions (10)
ufnGetAccountingEndDate,
ufnGetAccountingStartDate,
ufnGetDocumentStatusText,
ufnGetProductDealerPrice,
ufnGetProductListPrice,
ufnGetProductStandardCost,
ufnGetPurchaseOrderStatusText,
ufnGetSalesOrderStatusText,
ufnGetStock,
ufnLeadingZeros