Northwind Database (Document! X Sample)
AdventureWorks Database / dbo Schema / dbo.Name User Defined Data Type
In This Topic
    dbo.Name User Defined Data Type
    In This Topic
    Properties
    Allow Identity
    Allow Nulls
    Base Typenvarchar
    Default
    Variable Length
    Length50
    Max Size100
    Numeric Precision0
    Numeric scale0
    Rule
    CollationSQL_Latin1_General_CP1_CI_AS
    Columns in which this object is used
     TableColumn NameDescription
     DepartmentName of the department.
     DepartmentName of the group to which the department belongs.
     ShiftShift description.
     AddressTypeAddress type description. For example, Billing, Home, or Shipping.
     ContactTypeContact type description.
     CountryRegionCountry or region name.
     PersonFirst name of the person.
     PersonMiddle name or middle initial of the person.
     PersonLast name of the person.
     PhoneNumberTypeName of the telephone number type
     StateProvinceState or province description.
     CultureCulture description.
     LocationLocation description.
     ProductName of the product.
     ProductCategoryCategory description.
     ProductModelProduct model description.
     ProductReviewName of the reviewer.
     ProductSubcategorySubcategory description.
     ScrapReasonFailure description.
     UnitMeasureUnit of measure description.
     ShipMethodShipping company name.
     VendorCompany name.
     CurrencyCurrency name.
     SalesReasonSales reason description.
     SalesReasonCategory the sales reason belongs to.
     SalesTaxRateTax rate description.
     SalesTerritorySales territory description
     StoreName of the store.
    SQL
    CREATE TYPE [dbo].[Name] FROM [nvarchar](50) NULL
    See Also