AdventureWorks Database
AW2016FullTextCatalog Full Text Catalog
db_accessadmin Role
db_backupoperator Role
db_datareader Role
db_datawriter Role
db_ddladmin Role
db_denydatareader Role
db_denydatawriter Role
db_owner Role
db_securityadmin Role
dbo Schema
dbo User
dbo.AccountNumber User Defined Data Type
dbo.AWBuildVersion Table
dbo.DatabaseLog Table
dbo.ErrorLog Table
dbo.Flag User Defined Data Type
dbo.Name User Defined Data Type
dbo.NameStyle User Defined Data Type
dbo.OrderNumber User Defined Data Type
dbo.Phone User Defined Data Type
dbo.ufnGetAccountingEndDate User Defined Function
dbo.ufnGetAccountingStartDate User Defined Function
dbo.ufnGetContactInformation User Defined Function
dbo.ufnGetDocumentStatusText User Defined Function
dbo.ufnGetProductDealerPrice User Defined Function
dbo.ufnGetProductListPrice User Defined Function
dbo.ufnGetProductStandardCost User Defined Function
dbo.ufnGetPurchaseOrderStatusText User Defined Function
dbo.ufnGetSalesOrderStatusText User Defined Function
dbo.ufnGetStock User Defined Function
dbo.ufnLeadingZeros User Defined Function
dbo.uspGetBillOfMaterials Stored Procedure
dbo.uspGetEmployeeManagers Stored Procedure
dbo.uspGetManagerEmployees Stored Procedure
dbo.uspGetWhereUsedProductID Stored Procedure
dbo.uspLogError Stored Procedure
dbo.uspPrintError Stored Procedure
dbo.uspSearchCandidateResumes Stored Procedure
guest User
HumanResources Schema
HumanResources.Department Table
HumanResources.Employee Table
HumanResources.EmployeeDepartmentHistory Table
HumanResources.EmployeePayHistory Table
HumanResources.JobCandidate Table
HumanResources.Shift Table
HumanResources.uspUpdateEmployeeHireInfo Stored Procedure
HumanResources.uspUpdateEmployeeLogin Stored Procedure
HumanResources.uspUpdateEmployeePersonalInfo Stored Procedure
HumanResources.vEmployee View
HumanResources.vEmployeeDepartment View
HumanResources.vEmployeeDepartmentHistory View
HumanResources.vJobCandidate View
HumanResources.vJobCandidateEducation View
HumanResources.vJobCandidateEmployment View
INFORMATION_SCHEMA User
Person Schema
Person.Address Table
Person.AddressType Table
Person.BusinessEntity Table
Person.BusinessEntityAddress Table
Person.BusinessEntityContact Table
Person.ContactType Table
Person.CountryRegion Table
Person.EmailAddress Table
Person.Password Table
Person.Person Table
Person.PersonPhone Table
Person.PhoneNumberType Table
Person.StateProvince Table
Person.vAdditionalContactInfo View
Person.vStateProvinceCountryRegion View
PRIMARY File Group
Production Schema
Production.BillOfMaterials Table
Production.Culture Table
Production.Document Table
Production.Illustration Table
Production.Location Table
Production.Product Table
Production.ProductCategory Table
Production.ProductCostHistory Table
Production.ProductDescription Table
Production.ProductDocument Table
Production.ProductInventory Table
Production.ProductListPriceHistory Table
Production.ProductModel Table
Production.ProductModelIllustration Table
Production.ProductModelProductDescriptionCulture Table
Production.ProductPhoto Table
Production.ProductProductPhoto Table
Production.ProductReview Table
Production.ProductSubcategory Table
Production.ScrapReason Table
Production.TransactionHistory Table
Production.TransactionHistoryArchive Table
Production.UnitMeasure Table
Production.vProductAndDescription View
Production.vProductModelCatalogDescription View
Production.vProductModelInstructions View
Production.WorkOrder Table
Production.WorkOrderRouting Table
public Role
Purchasing Schema
Purchasing.ProductVendor Table
Purchasing.PurchaseOrderDetail Table
Purchasing.PurchaseOrderHeader Table
Purchasing.ShipMethod Table
Purchasing.Vendor Table
Purchasing.vVendorWithAddresses View
Purchasing.vVendorWithContacts View
Sales Schema
Sales.CountryRegionCurrency Table
Sales.CreditCard Table
Sales.Currency Table
Sales.CurrencyRate Table
Sales.Customer Table
Sales.PersonCreditCard Table
Sales.SalesOrderDetail Table
Sales.SalesOrderHeader Table
Sales.SalesOrderHeaderSalesReason Table
Sales.SalesPerson Table
Sales.SalesPersonQuotaHistory Table
Sales.SalesReason Table
Sales.SalesTaxRate Table
Sales.SalesTerritory Table
Sales.SalesTerritoryHistory Table
Sales.ShoppingCartItem Table
Sales.SpecialOffer Table
Sales.SpecialOfferProduct Table
Sales.Store Table
Sales.vIndividualCustomer View
Sales.vPersonDemographics View
Sales.vSalesPerson View
Sales.vSalesPersonSalesByFiscalYears View
Sales.vStoreWithAddresses View
Sales.vStoreWithContacts View
Sales.vStoreWithDemographics View
sys User