Northwind Database (Document! X Sample)
AdventureWorks Database
/
dbo Schema
/ dbo.Name User Defined Data Type
Collapse All
Expand All
In This Topic
Properties
Columns in which this object is used
SQL
See Also
Sample Template
Classic
Material
Light
About This Sample
AdventureWorks Database
Overview
Schemas
dbo Schema
Overview
Tables
dbo.AWBuildVersion Table
Indexes
PK_AWBuildVersion_SystemInformationID Index
dbo.DatabaseLog Table
Indexes
PK_DatabaseLog_DatabaseLogID Index
dbo.ErrorLog Table
Indexes
PK_ErrorLog_ErrorLogID Index
Stored Procedures
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
User Defined Functions
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
User Defined Data Types
dbo.AccountNumber User Defined Data Type
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
HumanResources Schema
Person Schema
Production Schema
Purchasing Schema
Sales Schema
Users
dbo User
guest User
INFORMATION_SCHEMA User
sys User
Roles
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
public Role
File Groups
PRIMARY File Group
Full Text Catalogs
AW2016FullTextCatalog Full Text Catalog
dbo.Name User Defined Data Type
In This Topic
Properties
Columns in which this object is used
SQL
See Also
Properties
Allow Identity
Allow Nulls
Base Type
nvarchar
Default
Variable Length
Length
50
Max Size
100
Numeric Precision
0
Numeric scale
0
Rule
Collation
SQL_Latin1_General_CP1_CI_AS
Columns in which this object is used
Table
Column Name
Description
Department
Name
Name of the department.
Department
GroupName
Name of the group to which the department belongs.
Shift
Name
Shift description.
AddressType
Name
Address type description. For example, Billing, Home, or Shipping.
ContactType
Name
Contact type description.
CountryRegion
Name
Country or region name.
Person
FirstName
First name of the person.
Person
MiddleName
Middle name or middle initial of the person.
Person
LastName
Last name of the person.
PhoneNumberType
Name
Name of the telephone number type
StateProvince
Name
State or province description.
Culture
Name
Culture description.
Location
Name
Location description.
Product
Name
Name of the product.
ProductCategory
Name
Category description.
ProductModel
Name
Product model description.
ProductReview
ReviewerName
Name of the reviewer.
ProductSubcategory
Name
Subcategory description.
ScrapReason
Name
Failure description.
UnitMeasure
Name
Unit of measure description.
ShipMethod
Name
Shipping company name.
Vendor
Name
Company name.
Currency
Name
Currency name.
SalesReason
Name
Sales reason description.
SalesReason
ReasonType
Category the sales reason belongs to.
SalesTaxRate
Name
Tax rate description.
SalesTerritory
Name
Sales territory description
Store
Name
Name of the store.
SQL
CREATE
TYPE
[dbo]
.
[Name]
FROM
[nvarchar]
(
50
)
NULL
See Also
Related Objects
dbo Schema
AdventureWorks Database