Properties

Owner:	dbo
Base Type:	nvarchar
Dafault Name:
Default Owner:
Nullable:
Precision:
Scale:
Flags:	1
Allow Identity:
Length:	100
Variable Length:
Max Length:	50
Rule:
Rule Owner:
Collation:	Latin1_General_CS_AS
Description:

Bound objects

	Object Name	Owner	Object Type	Column
	AddressType	Person	Table	Name
	Contact	Person	Table	FirstName
	Contact	Person	Table	LastName
	Contact	Person	Table	MiddleName
	ContactType	Person	Table	Name
	CountryRegion	Person	Table	Name
	Culture	Production	Table	Name
	Currency	Sales	Table	Name
	Department	HumanResources	Table	GroupName
	Department	HumanResources	Table	Name
	Location	Production	Table	Name
	Product	Production	Table	Name
	ProductCategory	Production	Table	Name
	ProductModel	Production	Table	Name
	ProductReview	Production	Table	ReviewerName
	ProductSubcategory	Production	Table	Name
	SalesReason	Sales	Table	Name
	SalesReason	Sales	Table	ReasonType
	SalesTaxRate	Sales	Table	Name
	SalesTerritory	Sales	Table	Name
	ScrapReason	Production	Table	Name
	Shift	HumanResources	Table	Name
	ShipMethod	Purchasing	Table	Name
	StateProvince	Person	Table	Name
	Store	Sales	Table	Name
	UnitMeasure	Production	Table	Name
	vAdditionalContactInfo	Person	View	FirstName
	vAdditionalContactInfo	Person	View	LastName
	vAdditionalContactInfo	Person	View	MiddleName
	vEmployee	HumanResources	View	CountryRegionName
	vEmployee	HumanResources	View	FirstName
	vEmployee	HumanResources	View	LastName
	vEmployee	HumanResources	View	MiddleName
	vEmployee	HumanResources	View	StateProvinceName
	vEmployeeDepartment	HumanResources	View	Department
	vEmployeeDepartment	HumanResources	View	FirstName
	vEmployeeDepartment	HumanResources	View	GroupName
	vEmployeeDepartment	HumanResources	View	LastName
	vEmployeeDepartment	HumanResources	View	MiddleName
	vEmployeeDepartmentHistory	HumanResources	View	Department
	vEmployeeDepartmentHistory	HumanResources	View	FirstName
	vEmployeeDepartmentHistory	HumanResources	View	GroupName
	vEmployeeDepartmentHistory	HumanResources	View	LastName
	vEmployeeDepartmentHistory	HumanResources	View	MiddleName
	vEmployeeDepartmentHistory	HumanResources	View	Shift
	Vendor	Purchasing	Table	Name
	vIndividualCustomer	Sales	View	AddressType
	vIndividualCustomer	Sales	View	CountryRegionName
	vIndividualCustomer	Sales	View	FirstName
	vIndividualCustomer	Sales	View	LastName
	vIndividualCustomer	Sales	View	MiddleName
	vIndividualCustomer	Sales	View	StateProvinceName
	vProductAndDescription	Production	View	Name
	vProductAndDescription	Production	View	ProductModel
	vProductModelCatalogDescription	Production	View	Name
	vProductModelInstructions	Production	View	Name
	vSalesPerson	Sales	View	CountryRegionName
	vSalesPerson	Sales	View	FirstName
	vSalesPerson	Sales	View	LastName
	vSalesPerson	Sales	View	MiddleName
	vSalesPerson	Sales	View	StateProvinceName
	vSalesPerson	Sales	View	TerritoryName
	vSalesPersonSalesByFiscalYears	Sales	View	SalesTerritory
	vStateProvinceCountryRegion	Person	View	CountryRegionName
	vStateProvinceCountryRegion	Person	View	StateProvinceName
	vStoreWithDemographics	Sales	View	AddressType
	vStoreWithDemographics	Sales	View	ContactType
	vStoreWithDemographics	Sales	View	CountryRegionName
	vStoreWithDemographics	Sales	View	FirstName
	vStoreWithDemographics	Sales	View	LastName
	vStoreWithDemographics	Sales	View	MiddleName
	vStoreWithDemographics	Sales	View	Name
	vStoreWithDemographics	Sales	View	StateProvinceName
	vVendor	Purchasing	View	ContactType
	vVendor	Purchasing	View	CountryRegionName
	vVendor	Purchasing	View	FirstName
	vVendor	Purchasing	View	LastName
	vVendor	Purchasing	View	MiddleName
	vVendor	Purchasing	View	Name
	vVendor	Purchasing	View	StateProvinceName

Total: 80 bound object(s)

SQL

EXEC sp_addtype N'Name', N'nvarchar (50)', N'null'
GO

See Also

List of datatypes