Northwind Database (Document! X Sample)
dbo.OrderNumber User Defined Data Type
AdventureWorks Database > dbo Schema : dbo.OrderNumber User Defined Data Type
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
 SalesOrderHeaderCustomer purchase order number reference.
SQL
CREATE TYPE [dbo].[OrderNumber] FROM [nvarchar](25) NULL
See Also

Related Objects

dbo Schema
AdventureWorks Database