Northwind Database (Document! X Sample)
AdventureWorks Database / dbo Schema / dbo.Phone User Defined Data Type
In This Topic
    dbo.Phone User Defined Data Type
    In This Topic
    Properties
    Allow Identity
    Allow Nulls
    Base Typenvarchar
    Default
    Variable Length
    Length25
    Max Size50
    Numeric Precision0
    Numeric scale0
    Rule
    CollationSQL_Latin1_General_CP1_CI_AS
    Columns in which this object is used
     TableColumn NameDescription
    Primary Key PersonPhonePhoneNumberTelephone number identification number.
    SQL
    CREATE TYPE [dbo].[Phone] FROM [nvarchar](25) NULL
    See Also

    Related Objects

    dbo Schema
    AdventureWorks Database

     

     

    © 2018 All Rights Reserved.

    Send comments on this topic.