Datatype: [AdventureWorks2016CTP3].[dbo].[Phone]
Properties
| Name | Value |
| Name | [Phone] |
| Schema | [dbo] | Owner | [dbo] |
| Storage type | nvarchar |
| Maximum length (chars or Bytes) | 25 |
| Precision | 25 |
| Scale | 0 |
| Allow nulls | ![]() |
| Rule | |
| Default | |
| ID | 262 |
| Is assembly type | |
| Is table type | |
| Is memory optimized |
Columns defined on
| Name | Parent | Description |
| PhoneNumber | [HumanResources].[vEmployee] | |
| PhoneNumber | [Person].[PersonPhone] | |
| PhoneNumber | [Purchasing].[vVendorWithContacts] | |
| PhoneNumber | [Sales].[vIndividualCustomer] | |
| PhoneNumber | [Sales].[vSalesPerson] | |
| PhoneNumber | [Sales].[vStoreWithContacts] |
Objects that depend on [dbo].[Phone]
| Object name | Object type | Dep level |
| [Person].[PersonPhone] | Table | 1 |
SQL
CREATE TYPE [dbo].[Phone] FROM [nvarchar](25) NULL GO |
See also