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