# Datatype: NameStyle

## Properties

Property | Value
--- | ---
Name | NameStyle
ID | 259
Schema | dbo
Owner | dbo
User Defined |
Native Datatype | bit
Max Length (in bytes) | 1
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

## [NameStyle] 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
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
NameStyle | Person.Person | 0 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order. mobi czwartek |  |  |  |  |  |  |  |  |  |  |  |

## [NameStyle] is used in the following parameters

Datatype is not used in any parameters

## Objects that depend on [NameStyle]

- dbo.NameStyle
  - Person.Person
    - dbo.ufnGetContactInformation
    - dbo.uspGetEmployeeManagers
    - dbo.uspGetManagerEmployees
    - HumanResources.Employee
      - dbo.vMobiEmployee
        - dbo.uMobiEmployeeTrg
      - HumanResources.dEmployee
      - HumanResources.EmployeeDepartmentHistory
        - HumanResources.vEmployeeDepartment
        - HumanResources.vEmployeeDepartmentHistory
      - HumanResources.EmployeePayHistory
        - HumanResources.uspUpdateEmployeeHireInfo
      - HumanResources.JobCandidate
        - dbo.uspSearchCandidateResumes
        - HumanResources.vJobCandidate
        - HumanResources.vJobCandidateEducation
        - HumanResources.vJobCandidateEmployment
      - HumanResources.uspUpdateEmployeeLogin
      - HumanResources.uspUpdateEmployeePersonalInfo
      - HumanResources.vEmployee
      - Production.Document
        - Production.ProductDocument
      - Purchasing.PurchaseOrderHeader
        - Purchasing.PurchaseOrderDetail
          - Purchasing.iPurchaseOrderDetail
          - Purchasing.uPurchaseOrderDetail
        - Purchasing.uPurchaseOrderHeader
      - Sales.SalesPerson
        - Sales.SalesOrderHeader
          - Sales.SalesOrderDetail
            - Sales.iduSalesOrderDetail
            - Sales.ufn_SalesByStore
          - Sales.SalesOrderHeaderSalesReason
          - Sales.uSalesOrderHeader
          - Sales.vSalesPersonSalesByFiscalYears
        - Sales.SalesPersonQuotaHistory
        - Sales.SalesTerritoryHistory
        - Sales.Store
          - Sales.Customer
            - Sales.vIndividualCustomer
          - Sales.vStoreWithAddresses
          - Sales.vStoreWithContacts
          - Sales.vStoreWithDemographics
        - Sales.vSalesPerson
    - Person.BusinessEntityContact
      - Purchasing.vVendorWithContacts
    - Person.EmailAddress
    - Person.iuPerson
    - Person.Password
    - Person.PersonPhone
    - Person.vAdditionalContactInfo
    - Sales.PersonCreditCard
    - Sales.vPersonDemographics

## Objects on which [NameStyle] depends

- dbo.NameStyle

## SQL

Script
CREATE TYPE [dbo].[NameStyle] FROM [bit] NOT NULL

#### See also

List of Datatypes