# Datatype: Name

## Properties

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

## 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 |  |  |  |  |  |  |  |  |  |  |  |  |
Name | dbo.TestProduct |  |  |  |  |  |  |  |  |  |  |  |  |
Name | HumanResources.Department | Name of the department. |  |  |  |  |  |  |  |  |  |  |  |
GroupName | HumanResources.Department | Name of the group to which the department belongs. |  |  |  |  |  |  |  |  |  |  |  |
Name | HumanResources.Shift | Shift description. |  |  |  |  |  |  |  |  |  |  |  |
FirstName | HumanResources.vEmployee |  |  |  |  |  |  |  |  |  |  |  |  |
MiddleName | HumanResources.vEmployee |  |  |  |  |  |  |  |  |  |  |  |  |
LastName | HumanResources.vEmployee |  |  |  |  |  |  |  |  |  |  |  |  |
PhoneNumberType | HumanResources.vEmployee |  |  |  |  |  |  |  |  |  |  |  |  |
StateProvinceName | HumanResources.vEmployee |  |  |  |  |  |  |  |  |  |  |  |  |
CountryRegionName | HumanResources.vEmployee |  |  |  |  |  |  |  |  |  |  |  |  |
FirstName | HumanResources.vEmployeeDepartment |  |  |  |  |  |  |  |  |  |  |  |  |
MiddleName | HumanResources.vEmployeeDepartment |  |  |  |  |  |  |  |  |  |  |  |  |
LastName | HumanResources.vEmployeeDepartment |  |  |  |  |  |  |  |  |  |  |  |  |
Department | HumanResources.vEmployeeDepartment |  |  |  |  |  |  |  |  |  |  |  |  |
GroupName | HumanResources.vEmployeeDepartment |  |  |  |  |  |  |  |  |  |  |  |  |
FirstName | HumanResources.vEmployeeDepartmentHistory |  |  |  |  |  |  |  |  |  |  |  |  |
MiddleName | HumanResources.vEmployeeDepartmentHistory |  |  |  |  |  |  |  |  |  |  |  |  |
LastName | HumanResources.vEmployeeDepartmentHistory |  |  |  |  |  |  |  |  |  |  |  |  |
Shift | HumanResources.vEmployeeDepartmentHistory |  |  |  |  |  |  |  |  |  |  |  |  |
Department | HumanResources.vEmployeeDepartmentHistory |  |  |  |  |  |  |  |  |  |  |  |  |
GroupName | HumanResources.vEmployeeDepartmentHistory |  |  |  |  |  |  |  |  |  |  |  |  |
Name | Person.AddressType | Address type description. For example, Billing, Home, or Shipping. |  |  |  |  |  |  |  |  |  |  |  |
Name | Person.ContactType | Contact type description. |  |  |  |  |  |  |  |  |  |  |  |
Name | Person.CountryRegion | Country or region name. |  |  |  |  |  |  |  |  |  |  |  |
FirstName | Person.Person | First name of the person. mobi czwartek |  |  |  |  |  |  |  |  |  |  |  |
MiddleName | Person.Person | Middle name or middle initial of the person. mobi czwartek |  |  |  |  |  |  |  |  |  |  |  |
LastName | Person.Person | Last name of the person. mobi czwartek |  |  |  |  |  |  |  |  |  |  |  |
Name | Person.PhoneNumberType | Name of the telephone number type |  |  |  |  |  |  |  |  |  |  |  |
Name | Person.StateProvince | State or province description. |  |  |  |  |  |  |  |  |  |  |  |
FirstName | Person.vAdditionalContactInfo |  |  |  |  |  |  |  |  |  |  |  |  |
MiddleName | Person.vAdditionalContactInfo |  |  |  |  |  |  |  |  |  |  |  |  |
LastName | Person.vAdditionalContactInfo |  |  |  |  |  |  |  |  |  |  |  |  |
StateProvinceName | Person.vStateProvinceCountryRegion |  |  |  |  |  |  |  |  |  |  |  |  |
CountryRegionName | Person.vStateProvinceCountryRegion |  |  |  |  |  |  |  |  |  |  |  |  |
Name | Production.Culture | Culture description. |  |  |  |  |  |  |  |  |  |  |  |
Name | Production.Location | Location description. |  |  |  |  |  |  |  |  |  |  |  |
Name | Production.Product | Name of the product. |  |  |  |  |  |  |  |  |  |  |  |
Name | Production.ProductCategory | Category description. |  |  |  |  |  |  |  |  |  |  |  |
Name | Production.ProductModel | Product model description. |  |  |  |  |  |  |  |  |  |  |  |
ReviewerName | Production.ProductReview | Name of the reviewer. |  |  |  |  |  |  |  |  |  |  |  |
Name | Production.ProductSubcategory | Subcategory description. |  |  |  |  |  |  |  |  |  |  |  |
Name | Production.ScrapReason | Failure description. |  |  |  |  |  |  |  |  |  |  |  |
Name | Production.UnitMeasure | Unit of measure description. |  |  |  |  |  |  |  |  |  |  |  |
Name | Production.vProductAndDescription |  |  |  |  |  |  |  |  |  |  |  |  |
ProductModel | Production.vProductAndDescription |  |  |  |  |  |  |  |  |  |  |  |  |
Name | Production.vProductModelCatalogDescription |  |  |  |  |  |  |  |  |  |  |  |  |
Name | Production.vProductModelInstructions |  |  |  |  |  |  |  |  |  |  |  |  |
Name | Purchasing.ShipMethod | Shipping company name. |  |  |  |  |  |  |  |  |  |  |  |
Name | Purchasing.Vendor | Company name. |  |  |  |  |  |  |  |  |  |  |  |
Name | Purchasing.vVendorWithAddresses |  |  |  |  |  |  |  |  |  |  |  |  |
AddressType | Purchasing.vVendorWithAddresses |  |  |  |  |  |  |  |  |  |  |  |  |
StateProvinceName | Purchasing.vVendorWithAddresses |  |  |  |  |  |  |  |  |  |  |  |  |
CountryRegionName | Purchasing.vVendorWithAddresses |  |  |  |  |  |  |  |  |  |  |  |  |
Name | Purchasing.vVendorWithContacts |  |  |  |  |  |  |  |  |  |  |  |  |
ContactType | Purchasing.vVendorWithContacts |  |  |  |  |  |  |  |  |  |  |  |  |
FirstName | Purchasing.vVendorWithContacts |  |  |  |  |  |  |  |  |  |  |  |  |
MiddleName | Purchasing.vVendorWithContacts |  |  |  |  |  |  |  |  |  |  |  |  |
LastName | Purchasing.vVendorWithContacts |  |  |  |  |  |  |  |  |  |  |  |  |
PhoneNumberType | Purchasing.vVendorWithContacts |  |  |  |  |  |  |  |  |  |  |  |  |
Name | Sales.Currency | Currency name. |  |  |  |  |  |  |  |  |  |  |  |
Name | Sales.SalesReason | Sales reason description. |  |  |  |  |  |  |  |  |  |  |  |
ReasonType | Sales.SalesReason | Category the sales reason belongs to. |  |  |  |  |  |  |  |  |  |  |  |
Name | Sales.SalesTaxRate | Tax rate description. |  |  |  |  |  |  |  |  |  |  |  |
Name | Sales.SalesTerritory | Sales territory description |  |  |  |  |  |  |  |  |  |  |  |
Name | Sales.Store | Name of the store. |  |  |  |  |  |  |  |  |  |  |  |
Name | Sales.ufn_SalesByStore |  |  |  |  |  |  |  |  |  |  |  |  |
PhoneNumberType | Sales.vIndividualCustomer |  |  |  |  |  |  |  |  |  |  |  |  |
AddressType | Sales.vIndividualCustomer |  |  |  |  |  |  |  |  |  |  |  |  |
StateProvinceName | Sales.vIndividualCustomer |  |  |  |  |  |  |  |  |  |  |  |  |
CountryRegionName | Sales.vIndividualCustomer |  |  |  |  |  |  |  |  |  |  |  |  |
FirstName | Sales.vIndividualCustomer |  |  |  |  |  |  |  |  |  |  |  |  |
MiddleName | Sales.vIndividualCustomer |  |  |  |  |  |  |  |  |  |  |  |  |
LastName | Sales.vIndividualCustomer |  |  |  |  |  |  |  |  |  |  |  |  |
FirstName | Sales.vSalesPerson |  |  |  |  |  |  |  |  |  |  |  |  |
MiddleName | Sales.vSalesPerson |  |  |  |  |  |  |  |  |  |  |  |  |
LastName | Sales.vSalesPerson |  |  |  |  |  |  |  |  |  |  |  |  |
PhoneNumberType | Sales.vSalesPerson |  |  |  |  |  |  |  |  |  |  |  |  |
StateProvinceName | Sales.vSalesPerson |  |  |  |  |  |  |  |  |  |  |  |  |
CountryRegionName | Sales.vSalesPerson |  |  |  |  |  |  |  |  |  |  |  |  |
TerritoryName | Sales.vSalesPerson |  |  |  |  |  |  |  |  |  |  |  |  |
SalesTerritory | Sales.vSalesPersonSalesByFiscalYears |  |  |  |  |  |  |  |  |  |  |  |  |
Name | Sales.vStoreWithAddresses |  |  |  |  |  |  |  |  |  |  |  |  |
AddressType | Sales.vStoreWithAddresses |  |  |  |  |  |  |  |  |  |  |  |  |
StateProvinceName | Sales.vStoreWithAddresses |  |  |  |  |  |  |  |  |  |  |  |  |
CountryRegionName | Sales.vStoreWithAddresses |  |  |  |  |  |  |  |  |  |  |  |  |
Name | Sales.vStoreWithContacts |  |  |  |  |  |  |  |  |  |  |  |  |
ContactType | Sales.vStoreWithContacts |  |  |  |  |  |  |  |  |  |  |  |  |
FirstName | Sales.vStoreWithContacts |  |  |  |  |  |  |  |  |  |  |  |  |
MiddleName | Sales.vStoreWithContacts |  |  |  |  |  |  |  |  |  |  |  |  |
LastName | Sales.vStoreWithContacts |  |  |  |  |  |  |  |  |  |  |  |  |
PhoneNumberType | Sales.vStoreWithContacts |  |  |  |  |  |  |  |  |  |  |  |  |
Name | Sales.vStoreWithDemographics |  |  |  |  |  |  |  |  |  |  |  |  |

## [Name] is used in the following parameters

Datatype is not used in any parameters

## Objects that depend on [Name]

- dbo.Name
  - dbo.TestProduct
  - HumanResources.Department
    - HumanResources.EmployeeDepartmentHistory
      - HumanResources.vEmployeeDepartment
      - HumanResources.vEmployeeDepartmentHistory
  - HumanResources.Shift
  - Person.AddressType
    - Person.BusinessEntityAddress
      - HumanResources.vEmployee
      - Purchasing.vVendorWithAddresses
      - Sales.vIndividualCustomer
      - Sales.vSalesPerson
      - Sales.vStoreWithAddresses
  - Person.ContactType
    - dbo.ufnGetContactInformation
    - Person.BusinessEntityContact
      - Purchasing.vVendorWithContacts
      - Sales.vStoreWithContacts
  - Person.CountryRegion
    - Person.StateProvince
      - Person.Address
        - Sales.SalesOrderHeader
          - Sales.SalesOrderDetail
            - Sales.iduSalesOrderDetail
            - Sales.ufn_SalesByStore
          - Sales.SalesOrderHeaderSalesReason
          - Sales.uSalesOrderHeader
          - Sales.vSalesPersonSalesByFiscalYears
      - Person.vStateProvinceCountryRegion
      - Sales.SalesTaxRate
    - Sales.CountryRegionCurrency
    - Sales.SalesTerritory
      - Sales.Customer
      - Sales.SalesPerson
        - Sales.SalesPersonQuotaHistory
        - Sales.SalesTerritoryHistory
        - Sales.Store
          - Sales.vStoreWithDemographics
  - Person.Person
    - dbo.uspGetEmployeeManagers
    - dbo.uspGetManagerEmployees
    - HumanResources.Employee
      - dbo.vMobiEmployee
        - dbo.uMobiEmployeeTrg
      - HumanResources.dEmployee
      - HumanResources.EmployeePayHistory
        - HumanResources.uspUpdateEmployeeHireInfo
      - HumanResources.JobCandidate
        - dbo.uspSearchCandidateResumes
        - HumanResources.vJobCandidate
        - HumanResources.vJobCandidateEducation
        - HumanResources.vJobCandidateEmployment
      - HumanResources.uspUpdateEmployeeLogin
      - HumanResources.uspUpdateEmployeePersonalInfo
      - Production.Document
        - Production.ProductDocument
      - Purchasing.PurchaseOrderHeader
        - Purchasing.PurchaseOrderDetail
          - Purchasing.iPurchaseOrderDetail
          - Purchasing.uPurchaseOrderDetail
        - Purchasing.uPurchaseOrderHeader
    - Person.EmailAddress
    - Person.iuPerson
    - Person.Password
    - Person.PersonPhone
    - Person.vAdditionalContactInfo
    - Sales.PersonCreditCard
    - Sales.vPersonDemographics
  - Person.PhoneNumberType
  - Production.Culture
    - Production.ProductModelProductDescriptionCulture
      - Production.vProductAndDescription
  - Production.Location
    - Production.ProductInventory
      - dbo.ufnGetStock
    - Production.WorkOrderRouting
  - Production.Product
    - dbo.KrystianProductView
    - dbo.ufnGetProductDealerPrice
      - Person.functionSynonym
    - dbo.ufnGetProductListPrice
    - dbo.ufnGetProductStandardCost
    - dbo.uspGetBillOfMaterials
      - HumanResources.ProcedureSynonym
    - dbo.uspGetWhereUsedProductID
    - Production.BillOfMaterials
    - Production.ProductCostHistory
    - Production.ProductListPriceHistory
    - Production.ProductProductPhoto
    - Production.ProductReview
    - Production.TransactionHistory
      - Production.WorkOrder
        - Production.iWorkOrder
        - Production.uWorkOrder
    - Production.uspGetList
    - Purchasing.ProductVendor
    - Sales.ShoppingCartItem
    - Sales.SpecialOfferProduct
  - Production.ProductCategory
    - Production.ProductSubcategory
  - Production.ProductModel
    - Production.ProductModelIllustration
    - Production.vProductModelCatalogDescription
    - Production.vProductModelInstructions
  - Production.ScrapReason
  - Production.UnitMeasure
  - Purchasing.ShipMethod
    - db_owner.tableSynonym
  - Purchasing.Vendor
    - Purchasing.dVendor
  - Sales.Currency
    - dbo.uspCurrencyCursor
    - Sales.CurrencyRate
  - Sales.SalesReason

## Objects on which [Name] depends

- dbo.Name

## SQL

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

#### See also

List of Datatypes