dbo.Phone User Defined Data Type

Northwind Database (Document! X Sample)

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
	PersonPhone	PhoneNumber	Telephone number identification number.

SQL

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

See Also

Related Objects

dbo Schema
AdventureWorks Database

© 2018 All Rights Reserved.

Send comments on this topic.