dbo.Name User Defined Data Type

Properties

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