Northwind Database (Document! X Sample)
dbo.AccountNumber User Defined Data Type
AdventureWorks Database > dbo Schema : dbo.AccountNumber User Defined Data Type
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
 VendorVendor account (identification) number.
 SalesOrderHeaderFinancial accounting number reference.
SQL
CREATE TYPE [dbo].[AccountNumber] FROM [nvarchar](15) NULL
See Also

Related Objects

dbo Schema
AdventureWorks Database