Northwind Database (Document! X Sample)
dbo Schema
AdventureWorks Database : dbo Schema
Tables
TableDescription
dbo.AWBuildVersionCurrent version number of the AdventureWorks 2016 sample database.
dbo.DatabaseLogAudit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.
dbo.ErrorLogAudit table tracking errors in the the AdventureWorks database that are caught by the CATCH block of a TRY...CATCH construct. Data is inserted by stored procedure dbo.uspLogError when it is executed from inside the CATCH block of a TRY...CATCH construct.
Stored Procedures
Stored ProcedureDescription
dbo.uspGetBillOfMaterialsStored procedure using a recursive query to return a multi-level bill of material for the specified ProductID.
dbo.uspGetEmployeeManagersStored procedure using a recursive query to return the direct and indirect managers of the specified employee.
dbo.uspGetManagerEmployeesStored procedure using a recursive query to return the direct and indirect employees of the specified manager.
dbo.uspGetWhereUsedProductIDStored procedure using a recursive query to return all components or assemblies that directly or indirectly use the specified ProductID.
dbo.uspLogErrorLogs error information in the ErrorLog table about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without inserting error information.
dbo.uspPrintErrorPrints error information about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without printing any error information.
dbo.uspSearchCandidateResumes 
User Defined Functions
User Defined FunctionDescription
dbo.ufnGetAccountingEndDateScalar function used in the uSalesOrderHeader trigger to set the starting account date.
dbo.ufnGetAccountingStartDateScalar function used in the uSalesOrderHeader trigger to set the ending account date.
dbo.ufnGetContactInformationTable value function returning the first name, last name, job title and contact type for a given contact.
dbo.ufnGetDocumentStatusTextScalar function returning the text representation of the Status column in the Document table.
dbo.ufnGetProductDealerPriceScalar function returning the dealer price for a given product on a particular order date.
dbo.ufnGetProductListPriceScalar function returning the list price for a given product on a particular order date.
dbo.ufnGetProductStandardCostScalar function returning the standard cost for a given product on a particular order date.
dbo.ufnGetPurchaseOrderStatusTextScalar function returning the text representation of the Status column in the PurchaseOrderHeader table.
dbo.ufnGetSalesOrderStatusTextScalar function returning the text representation of the Status column in the SalesOrderHeader table.
dbo.ufnGetStockScalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID.
dbo.ufnLeadingZerosScalar function used by the Sales.Customer table to help set the account number.
User Defined Data Types
User Defined Data TypeDescription
dbo.AccountNumber 
dbo.Flag 
dbo.Name 
dbo.NameStyle 
dbo.OrderNumber 
dbo.Phone 
See Also

Related Objects

AdventureWorks Database

 

 

© 2018 All Rights Reserved.

Send comments on this topic.