datatype icon Datatype: Phone

Properties

Property Value
Name Phone
ID 262
Schema dbo
Owner dbo
User Defined true
Native Datatype nvarchar(25)
Max Length (in bytes) 50
Nullable true
Is Assembly Type false
Is Table Type false

Extended Properties

No extended properties defined.

Bound Defaults

No defaults bound to that datatype

Bound Rules

No rules bound to that datatype

[Phone] is used in the following columns

Column Name Object Name Description ANSI Padded Is Rowguidcol Is Identity Is Computed Is Filestream Is Replicated Is Non Sql Subscribed Is Merge Published Is DTS Replicated Is Xml Document Is Sparse Is Column Set
PhoneNumber HumanResources.vEmployee true false false false false false false false false false false false
PhoneNumber Person.PersonPhone Telephone number identification number. true false false false false false false false false false false false
PhoneNumber Purchasing.vVendorWithContacts true false false false false false false false false false false false
PhoneNumber Sales.vIndividualCustomer true false false false false false false false false false false false
PhoneNumber Sales.vSalesPerson true false false false false false false false false false false false
PhoneNumber Sales.vStoreWithContacts true false false false false false false false false false false false

[Phone] is used in the following parameters

Datatype is not used in any parameters

Objects that depend on [Phone]

Objects on which [Phone] depends

SQL

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

See also

List of Datatypes