Object type: User defined type

Properties 

New data type	Derived from	Nullable	User
Name	nvarchar(50)	Yes	—

Referring tables 

Name	Description
HumanResources.Department	Lookup table containing the departments within the Adventure Works Cycles company.
HumanResources.Shift	Work shift lookup table.
Person.AddressType	Types of addresses stored in the Address table.
Person.Contact	Names of each employee, customer contact, and vendor contact.
Person.ContactType	Lookup table containing the types of contacts stored in Contact.
Person.CountryRegion	Lookup table containing the ISO standard codes for countries and regions.
Person.StateProvince	State and province lookup table.
Production.Culture	Lookup table containing the languages in which some AdventureWorks data is stored.
Production.Location	Product inventory and manufacturing locations.
Production.Product	Products sold or used in the manfacturing of sold products.
Production.ProductCategory	High-level product categorization.
Production.ProductModel	Product model classification.
Production.ProductReview	Customer reviews of products they have purchased.
Production.ProductSubcategory	Product subcategories. See ProductCategory table.
Production.ScrapReason	Manufacturing failure reasons lookup table.
Production.UnitMeasure	Unit of measure lookup table.
Purchasing.ShipMethod	Shipping company lookup table.
Purchasing.Vendor	Companies from whom Adventure Works Cycles purchases parts or other goods.
Sales.Currency	Lookup table containing standard ISO currencies.
Sales.SalesReason	Lookup table of customer purchase reasons.
Sales.SalesTaxRate	Tax rate lookup table.
Sales.SalesTerritory	Sales territory lookup table.
Sales.Store	Customers (resellers) of Adventure Works products.

Applies to

User defined types

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation