# Datatype: Phone

## Properties

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

## 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 |  |  |  |  |  |  |  |  |  |  |  |  |
PhoneNumber | Person.PersonPhone | Telephone number identification number. |  |  |  |  |  |  |  |  |  |  |  |
PhoneNumber | Purchasing.vVendorWithContacts |  |  |  |  |  |  |  |  |  |  |  |  |
PhoneNumber | Sales.vIndividualCustomer |  |  |  |  |  |  |  |  |  |  |  |  |
PhoneNumber | Sales.vSalesPerson |  |  |  |  |  |  |  |  |  |  |  |  |
PhoneNumber | Sales.vStoreWithContacts |  |  |  |  |  |  |  |  |  |  |  |  |

## [Phone] is used in the following parameters

Datatype is not used in any parameters

## Objects that depend on [Phone]

- dbo.Phone
  - Person.PersonPhone
    - HumanResources.vEmployee
    - Purchasing.vVendorWithContacts
    - Sales.vIndividualCustomer
    - Sales.vSalesPerson
    - Sales.vStoreWithContacts

## Objects on which [Phone] depends

- dbo.Phone

## SQL

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

#### See also

List of Datatypes