datatype icon Datatype: Name

Properties

Property Value
Name Name
ID 260
Schema dbo
Owner dbo
User Defined true
Native Datatype nvarchar(50)
Max Length (in bytes) 100
Nullable true
Is Assembly Type false
Is Table Type false

Extended Properties

No extended properties defined.

Bound Defaults

No defaults bound to that datatype

Bound Rules

No rules bound to that datatype

[Name] is used in the following columns

Column Name Object Name Description ANSI Padded Is Rowguidcol Is Identity Is Computed Is Filestream Is Replicated Is Non Sql Subscribed Is Merge Published Is DTS Replicated Is Xml Document Is Sparse Is Column Set
Name dbo.KrystianProductView true false false false false false false false false false false false
Name dbo.TestProduct true false false false false false false false false false false false
Name HumanResources.Department Name of the department. true false false false false false false false false false false false
GroupName HumanResources.Department Name of the group to which the department belongs. true false false false false false false false false false false false
Name HumanResources.Shift Shift description. true false false false false false false false false false false false
FirstName HumanResources.vEmployee true false false false false false false false false false false false
MiddleName HumanResources.vEmployee true false false false false false false false false false false false
LastName HumanResources.vEmployee true false false false false false false false false false false false
PhoneNumberType HumanResources.vEmployee true false false false false false false false false false false false
StateProvinceName HumanResources.vEmployee true false false false false false false false false false false false
CountryRegionName HumanResources.vEmployee true false false false false false false false false false false false
FirstName HumanResources.vEmployeeDepartment true false false false false false false false false false false false
MiddleName HumanResources.vEmployeeDepartment true false false false false false false false false false false false
LastName HumanResources.vEmployeeDepartment true false false false false false false false false false false false
Department HumanResources.vEmployeeDepartment true false false false false false false false false false false false
GroupName HumanResources.vEmployeeDepartment true false false false false false false false false false false false
FirstName HumanResources.vEmployeeDepartmentHistory true false false false false false false false false false false false
MiddleName HumanResources.vEmployeeDepartmentHistory true false false false false false false false false false false false
LastName HumanResources.vEmployeeDepartmentHistory true false false false false false false false false false false false
Shift HumanResources.vEmployeeDepartmentHistory true false false false false false false false false false false false
Department HumanResources.vEmployeeDepartmentHistory true false false false false false false false false false false false
GroupName HumanResources.vEmployeeDepartmentHistory true false false false false false false false false false false false
Name Person.AddressType Address type description. For example, Billing, Home, or Shipping. true false false false false false false false false false false false
Name Person.ContactType Contact type description. true false false false false false false false false false false false
Name Person.CountryRegion Country or region name. true false false false false false false false false false false false
FirstName Person.Person First name of the person. mobi czwartek true false false false false false false false false false false false
MiddleName Person.Person Middle name or middle initial of the person. mobi czwartek true false false false false false false false false false false false
LastName Person.Person Last name of the person. mobi czwartek true false false false false false false false false false false false
Name Person.PhoneNumberType Name of the telephone number type true false false false false false false false false false false false
Name Person.StateProvince State or province description. true false false false false false false false false false false false
FirstName Person.vAdditionalContactInfo true false false false false false false false false false false false
MiddleName Person.vAdditionalContactInfo true false false false false false false false false false false false
LastName Person.vAdditionalContactInfo true false false false false false false false false false false false
StateProvinceName Person.vStateProvinceCountryRegion true false false false false false false false false false false false
CountryRegionName Person.vStateProvinceCountryRegion true false false false false false false false false false false false
Name Production.Culture Culture description. true false false false false false false false false false false false
Name Production.Location Location description. true false false false false false false false false false false false
Name Production.Product Name of the product. true false false false false false false false false false false false
Name Production.ProductCategory Category description. true false false false false false false false false false false false
Name Production.ProductModel Product model description. true false false false false false false false false false false false
ReviewerName Production.ProductReview Name of the reviewer. true false false false false false false false false false false false
Name Production.ProductSubcategory Subcategory description. true false false false false false false false false false false false
Name Production.ScrapReason Failure description. true false false false false false false false false false false false
Name Production.UnitMeasure Unit of measure description. true false false false false false false false false false false false
Name Production.vProductAndDescription true false false false false false false false false false false false
ProductModel Production.vProductAndDescription true false false false false false false false false false false false
Name Production.vProductModelCatalogDescription true false false false false false false false false false false false
Name Production.vProductModelInstructions true false false false false false false false false false false false
Name Purchasing.ShipMethod Shipping company name. true false false false false false false false false false false false
Name Purchasing.Vendor Company name. true false false false false false false false false false false false
Name Purchasing.vVendorWithAddresses true false false false false false false false false false false false
AddressType Purchasing.vVendorWithAddresses true false false false false false false false false false false false
StateProvinceName Purchasing.vVendorWithAddresses true false false false false false false false false false false false
CountryRegionName Purchasing.vVendorWithAddresses true false false false false false false false false false false false
Name Purchasing.vVendorWithContacts true false false false false false false false false false false false
ContactType Purchasing.vVendorWithContacts true false false false false false false false false false false false
FirstName Purchasing.vVendorWithContacts true false false false false false false false false false false false
MiddleName Purchasing.vVendorWithContacts true false false false false false false false false false false false
LastName Purchasing.vVendorWithContacts true false false false false false false false false false false false
PhoneNumberType Purchasing.vVendorWithContacts true false false false false false false false false false false false
Name Sales.Currency Currency name. true false false false false false false false false false false false
Name Sales.SalesReason Sales reason description. true false false false false false false false false false false false
ReasonType Sales.SalesReason Category the sales reason belongs to. true false false false false false false false false false false false
Name Sales.SalesTaxRate Tax rate description. true false false false false false false false false false false false
Name Sales.SalesTerritory Sales territory description true false false false false false false false false false false false
Name Sales.Store Name of the store. true false false false false false false false false false false false
Name Sales.ufn_SalesByStore true false false false false false false false false false false false
PhoneNumberType Sales.vIndividualCustomer true false false false false false false false false false false false
AddressType Sales.vIndividualCustomer true false false false false false false false false false false false
StateProvinceName Sales.vIndividualCustomer true false false false false false false false false false false false
CountryRegionName Sales.vIndividualCustomer true false false false false false false false false false false false
FirstName Sales.vIndividualCustomer true false false false false false false false false false false false
MiddleName Sales.vIndividualCustomer true false false false false false false false false false false false
LastName Sales.vIndividualCustomer true false false false false false false false false false false false
FirstName Sales.vSalesPerson true false false false false false false false false false false false
MiddleName Sales.vSalesPerson true false false false false false false false false false false false
LastName Sales.vSalesPerson true false false false false false false false false false false false
PhoneNumberType Sales.vSalesPerson true false false false false false false false false false false false
StateProvinceName Sales.vSalesPerson true false false false false false false false false false false false
CountryRegionName Sales.vSalesPerson true false false false false false false false false false false false
TerritoryName Sales.vSalesPerson true false false false false false false false false false false false
SalesTerritory Sales.vSalesPersonSalesByFiscalYears true false false false false false false false false false false false
Name Sales.vStoreWithAddresses true false false false false false false false false false false false
AddressType Sales.vStoreWithAddresses true false false false false false false false false false false false
StateProvinceName Sales.vStoreWithAddresses true false false false false false false false false false false false
CountryRegionName Sales.vStoreWithAddresses true false false false false false false false false false false false
Name Sales.vStoreWithContacts true false false false false false false false false false false false
ContactType Sales.vStoreWithContacts true false false false false false false false false false false false
FirstName Sales.vStoreWithContacts true false false false false false false false false false false false
MiddleName Sales.vStoreWithContacts true false false false false false false false false false false false
LastName Sales.vStoreWithContacts true false false false false false false false false false false false
PhoneNumberType Sales.vStoreWithContacts true false false false false false false false false false false false
Name Sales.vStoreWithDemographics true false false false false false false false false false false false

[Name] is used in the following parameters

Datatype is not used in any parameters

Objects that depend on [Name]

Objects on which [Name] depends

SQL

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

See also

List of Datatypes