dbo.Phone User Defined Data Type

AdventureWorks

dbo.Phone User Defined Data Type

Collapse All

AdventureWorks Database > dbo Schema : dbo.Phone 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
	Contact	Phone	Phone number associated with the person.

SQL

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

See Also

Related Objects

dbo Schema
AdventureWorks Database

© 2012 All Rights Reserved.

Send comments on this topic.