Northwind Database (Document! X Sample)
AdventureWorks Database / dbo Schema / dbo.NameStyle User Defined Data Type
In This Topic
    dbo.NameStyle User Defined Data Type
    In This Topic
    Properties
    Allow Identity
    Allow Nulls
    Base Typebit
    Default
    Variable Length
    Length1
    Max Size1
    Numeric Precision1
    Numeric scale0
    Rule
    Collation
    Columns in which this object is used
     TableColumn NameDescription
     Person0 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order.
    SQL
    CREATE TYPE [dbo].[NameStyle] FROM [bit] NOT NULL
    See Also