Datatype: [AdventureWorks2016CTP3].[dbo].[AccountNumber]
Properties
| Name | Value |
| Name | [AccountNumber] |
| Schema | [dbo] | Owner | [dbo] |
| Storage type | nvarchar |
| Maximum length (chars or Bytes) | 15 |
| Precision | 15 |
| Scale | 0 |
| Allow nulls | ![]() |
| Rule | |
| Default | |
| ID | 257 |
| Is assembly type | |
| Is table type | |
| Is memory optimized |
Columns defined on
| Name | Parent | Description |
| AccountNumber | [Purchasing].[Vendor] | |
| AccountNumber | [Sales].[SalesOrder_json] | |
| AccountNumber | [Sales].[SalesOrderHeader] |
Objects that depend on [dbo].[AccountNumber]
| Object name | Object type | Dep level |
| [Sales].[SalesOrder_json] | Table | 1 |
| [Sales].[SalesOrderHeader] | Table | 1 |
| [Purchasing].[Vendor] | Table | 1 |
SQL
CREATE TYPE [dbo].[AccountNumber] FROM [nvarchar](15) NULL GO |
See also