Datatype: [AdventureWorks2016CTP3].[dbo].[Name]

CollapseAll image

Collapse image Properties


 Name   Value 
 Name   [Name] 
 Schema   [dbo] 
 Owner   [dbo] 
 Storage type   nvarchar 
 Maximum  length (chars or Bytes)   50 
 Precision   50 
 Scale   0 
 Allow nulls 
 Rule     
 Default     
 ID   260 
 Is assembly type    
 Is table type    
 Is memory optimized    

Collapse image Columns defined on


Name  Parent  Description
GroupName [HumanResources].[Department]  
Name [HumanResources].[Department]  
Name [HumanResources].[Shift]  
CountryRegionName [HumanResources].[vEmployee]  
FirstName [HumanResources].[vEmployee]  
LastName [HumanResources].[vEmployee]  
MiddleName [HumanResources].[vEmployee]  
PhoneNumberType [HumanResources].[vEmployee]  
StateProvinceName [HumanResources].[vEmployee]  
Department [HumanResources].[vEmployeeDepartment]  
FirstName [HumanResources].[vEmployeeDepartment]  
GroupName [HumanResources].[vEmployeeDepartment]  
LastName [HumanResources].[vEmployeeDepartment]  
MiddleName [HumanResources].[vEmployeeDepartment]  
Department [HumanResources].[vEmployeeDepartmentHistory]  
FirstName [HumanResources].[vEmployeeDepartmentHistory]  
GroupName [HumanResources].[vEmployeeDepartmentHistory]  
LastName [HumanResources].[vEmployeeDepartmentHistory]  
MiddleName [HumanResources].[vEmployeeDepartmentHistory]  
Shift [HumanResources].[vEmployeeDepartmentHistory]  
FirstName [HumanResources].[vEmployeePersonTemporalInfo]  
LastName [HumanResources].[vEmployeePersonTemporalInfo]  
MiddleName [HumanResources].[vEmployeePersonTemporalInfo]  
Name [Person].[AddressType]  
Name [Person].[ContactType]  
Name [Person].[CountryRegion]  
FirstName [Person].[Person]  
LastName [Person].[Person]  
MiddleName [Person].[Person]  
FirstName [Person].[Person_json]  
LastName [Person].[Person_json]  
MiddleName [Person].[Person_json]  
FirstName [Person].[Person_Temporal]  
LastName [Person].[Person_Temporal]  
MiddleName [Person].[Person_Temporal]  
FirstName [Person].[Person_Temporal_History]  
LastName [Person].[Person_Temporal_History]  
MiddleName [Person].[Person_Temporal_History]  
Name [Person].[PhoneNumberType]  
Name [Person].[StateProvince]  
FirstName [Person].[vAdditionalContactInfo]  
LastName [Person].[vAdditionalContactInfo]  
MiddleName [Person].[vAdditionalContactInfo]  
CountryRegionName [Person].[vStateProvinceCountryRegion]  
StateProvinceName [Person].[vStateProvinceCountryRegion]  
Name [Production].[Culture]  
Name [Production].[Location]  
Name [Production].[Product]  
Name [Production].[ProductCategory]  
Name [Production].[ProductModel]  
ReviewerName [Production].[ProductReview]  
Name [Production].[ProductSubcategory]  
Name [Production].[ScrapReason]  
Name [Production].[UnitMeasure]  
Name [Production].[vProductAndDescription]  
ProductModel [Production].[vProductAndDescription]  
Name [Production].[vProductModelCatalogDescription]  
Name [Production].[vProductModelInstructions]  
Name [Purchasing].[ShipMethod]  
Name [Purchasing].[Vendor]  
AddressType [Purchasing].[vVendorWithAddresses]  
CountryRegionName [Purchasing].[vVendorWithAddresses]  
Name [Purchasing].[vVendorWithAddresses]  
StateProvinceName [Purchasing].[vVendorWithAddresses]  
ContactType [Purchasing].[vVendorWithContacts]  
FirstName [Purchasing].[vVendorWithContacts]  
LastName [Purchasing].[vVendorWithContacts]  
MiddleName [Purchasing].[vVendorWithContacts]  
Name [Purchasing].[vVendorWithContacts]  
PhoneNumberType [Purchasing].[vVendorWithContacts]  
Name [Sales].[Currency]  
FirstName [Sales].[CustomerPII]  
LastName [Sales].[CustomerPII]  
Name [Sales].[SalesReason]  
ReasonType [Sales].[SalesReason]  
Name [Sales].[SalesTaxRate]  
Name [Sales].[SalesTerritory]  
Name [Sales].[Store]  
AddressType [Sales].[vIndividualCustomer]  
CountryRegionName [Sales].[vIndividualCustomer]  
FirstName [Sales].[vIndividualCustomer]  
LastName [Sales].[vIndividualCustomer]  
MiddleName [Sales].[vIndividualCustomer]  
PhoneNumberType [Sales].[vIndividualCustomer]  
StateProvinceName [Sales].[vIndividualCustomer]  
CountryRegionName [Sales].[vSalesPerson]  
FirstName [Sales].[vSalesPerson]  
LastName [Sales].[vSalesPerson]  
MiddleName [Sales].[vSalesPerson]  
PhoneNumberType [Sales].[vSalesPerson]  
StateProvinceName [Sales].[vSalesPerson]  
TerritoryName [Sales].[vSalesPerson]  
SalesTerritory [Sales].[vSalesPersonSalesByFiscalYears]  
AddressType [Sales].[vStoreWithAddresses]  
CountryRegionName [Sales].[vStoreWithAddresses]  
Name [Sales].[vStoreWithAddresses]  
StateProvinceName [Sales].[vStoreWithAddresses]  
ContactType [Sales].[vStoreWithContacts]  
FirstName [Sales].[vStoreWithContacts]  
LastName [Sales].[vStoreWithContacts]  
MiddleName [Sales].[vStoreWithContacts]  
Name [Sales].[vStoreWithContacts]  
PhoneNumberType [Sales].[vStoreWithContacts]  
Name [Sales].[vStoreWithDemographics]  
Total: 104 column(s)

Collapse image Objects that depend on [dbo].[Name]


Object name Object type Dep level
[Person].[AddressType] Table 1
[Person].[ContactType] Table 1
[Person].[CountryRegion] Table 1
[Production].[Culture] Table 1
[Sales].[Currency] Table 1
[Sales].[CustomerPII] Table 1
[HumanResources].[Department] Table 1
[Production].[Location] Table 1
[Person].[Person] Table 1
[Person].[Person_json] Table 1
[Person].[Person_Temporal] Table 1
[Person].[Person_Temporal_History] Table 1
[Person].[PhoneNumberType] Table 1
[Production].[Product] Table 1
[Production].[ProductCategory] Table 1
[Production].[ProductModel] Table 1
[Production].[ProductReview] Table 1
[Production].[ProductSubcategory] Table 1
[Sales].[SalesReason] Table 1
[Sales].[SalesTaxRate] Table 1
[Sales].[SalesTerritory] Table 1
[Production].[ScrapReason] Table 1
[HumanResources].[Shift] Table 1
[Purchasing].[ShipMethod] Table 1
[Person].[StateProvince] Table 1
[Sales].[Store] Table 1
[Production].[UnitMeasure] Table 1
[Purchasing].[Vendor] Table 1
Total 28 object(s)

Collapse image SQL


CREATE TYPE [dbo].[Name]
    FROM [nvarchar](50)
    NULL
GO

Collapse image See also


List of datatypes