dbo.AccountNumber User Defined Data Type

AdventureWorks

dbo.AccountNumber User Defined Data Type

Collapse All

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

Properties

Allow Identity
Allow Nulls
Base Type	nvarchar
Default
Variable Length
Length	15
Max Size	30
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
	Vendor	AccountNumber	Vendor account (identification) number.
	SalesOrderHeader	AccountNumber	Financial accounting number reference.

SQL

CREATE TYPE [dbo].[AccountNumber] FROM [nvarchar](15) NULL

See Also

Related Objects

dbo Schema
AdventureWorks Database

© 2012 All Rights Reserved.

Send comments on this topic.