Project
>
lsrep17
>
User databases
>
AdventureWorks
> Programmability > Types >
User-Defined Data Types
> dbo.Name
[dbo].[Name]
Properties
Property
Value
Allow Nulls
True
Base Type Name
nvarchar
Length
50
SQL Script
CREATE
TYPE
[dbo]
.
[Name]
FROM
nvarchar
(
50
)
NULL
GO
Used By
[HumanResources].[Department]
[HumanResources].[Shift]
[Person].[AddressType]
[Person].[ContactType]
[Person].[CountryRegion]
[Person].[Person]
[Person].[PhoneNumberType]
[Person].[StateProvince]
[Production].[Culture]
[Production].[Location]
[Production].[Product]
[Production].[ProductCategory]
[Production].[ProductModel]
[Production].[ProductReview]
[Production].[ProductSubcategory]
[Production].[ScrapReason]
[Production].[UnitMeasure]
[Purchasing].[ShipMethod]
[Purchasing].[Vendor]
[Sales].[Currency]
[Sales].[SalesReason]
[Sales].[SalesTaxRate]
[Sales].[SalesTerritory]
[Sales].[Store]
[HumanResources].[vEmployee]
[HumanResources].[vEmployeeDepartment]
[HumanResources].[vEmployeeDepartmentHistory]
[Person].[vAdditionalContactInfo]
[Person].[vStateProvinceCountryRegion]
[Production].[vProductAndDescription]
[Production].[vProductModelCatalogDescription]
[Production].[vProductModelInstructions]
[Purchasing].[vVendorWithAddresses]
[Purchasing].[vVendorWithContacts]
[Sales].[vIndividualCustomer]
[Sales].[vSalesPerson]
[Sales].[vSalesPersonSalesByFiscalYears]
[Sales].[vStoreWithAddresses]
[Sales].[vStoreWithContacts]
[Sales].[vStoreWithDemographics]