Datatype: [AdventureWorks2016CTP3].[Sales].[SalesOrderDetailType_ondisk]

CollapseAll image

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

Collapse image Columns defined on


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

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


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

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


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

Collapse image SQL


CREATE TYPE [Sales].[SalesOrderDetailType_ondisk]
AS TABLE (
        [OrderQty]           [smallint] NOT NULL,
        [ProductID]          [int] NOT NULL,
        [SpecialOfferID]     [int] NOT NULL
)
GO

Collapse image See also


List of datatypes