Datatype: [AdventureWorks2016CTP3].[Sales].[SalesOrderDetailType_ondisk]
Properties
| Name | Value |
| Name | [SalesOrderDetailType_ondisk] |
| Schema | [Sales] | Owner | [dbo] |
| Storage type | table type |
| Rule | |
| Default | |
| ID | 263 |
| Is assembly type | |
| Is table type | ![]() |
| Is memory optimized | |
| Table type object ID | 1460200252 |
Columns defined on
| Name | Parent | Description |
| @SalesOrderDetails | [Sales].[usp_InsertSalesOrder_ondisk] |
Objects that depend on [Sales].[SalesOrderDetailType_ondisk]
| Object name | Object type | Dep level |
| [Sales].[usp_InsertSalesOrder_ondisk] | Procedure | 1 |
Objects that [Sales].[SalesOrderDetailType_ondisk] depends on
| Object name | Object type | Dep level |
| [Sales] | Schema | 1 |
SQL
CREATE TYPE [Sales].[SalesOrderDetailType_ondisk] AS TABLE ( [OrderQty] [smallint] NOT NULL, [ProductID] [int] NOT NULL, [SpecialOfferID] [int] NOT NULL ) GO |
See also