Datatype: [AdventureWorks2016CTP3].[Sales].[SalesOrderDetailType_inmem]

CollapseAll image

Collapse image 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 

Collapse image Columns defined on


Name  Parent  Description
@SalesOrderDetails [Sales].[usp_InsertSalesOrder_inmem]  
Total: 1 column(s)

Collapse image Objects that depend on [Sales].[SalesOrderDetailType_inmem]


Object name Object type Dep level
[Sales].[usp_InsertSalesOrder_inmem] Procedure 1
Total 1 object(s)

Collapse image Objects that [Sales].[SalesOrderDetailType_inmem] depends on


Object name Object type Dep level
[Sales] Schema 1
Total 1 object(s)

Collapse image 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

Collapse image See also


List of datatypes