Northwind Database (Document! X Sample)
AdventureWorks Database / dbo Schema / dbo.AccountNumber User Defined Data Type
In This Topic
    dbo.AccountNumber User Defined Data Type
    In This Topic
    Properties
    Allow Identity
    Allow Nulls
    Base Typenvarchar
    Default
    Variable Length
    Length15
    Max Size30
    Numeric Precision0
    Numeric scale0
    Rule
    CollationSQL_Latin1_General_CP1_CI_AS
    Columns in which this object is used
     TableColumn NameDescription
     VendorAccountNumberVendor account (identification) number.
     SalesOrderHeaderAccountNumberFinancial accounting number reference.
    SQL
    CREATE TYPE [dbo].[AccountNumber] FROM [nvarchar](15) NULL
    See Also

    Related Objects

    dbo Schema
    AdventureWorks Database

     

     

    © 2018 All Rights Reserved.

    Send comments on this topic.