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