dbo.OrderNumber User Defined Data Type

AdventureWorks

dbo.OrderNumber User Defined Data Type

Collapse All

AdventureWorks Database > dbo Schema : dbo.OrderNumber User Defined Data Type

Properties

Allow Identity
Allow Nulls
Base Type	nvarchar
Default
Variable Length
Length	25
Max Size	50
Numeric Precision	0
Numeric scale	0
Rule
Collation	SQL_Latin1_General_CP1_CI_AS

Columns in which this object is used

	Table	Column Name	Description
	SalesOrderHeader	PurchaseOrderNumber	Customer purchase order number reference.

SQL

CREATE TYPE [dbo].[OrderNumber] FROM [nvarchar](25) NULL

See Also

Related Objects

dbo Schema
AdventureWorks Database

© 2012 All Rights Reserved.

Send comments on this topic.