Temporary Tables and the TableType Property [AX 2012]

Updated: November 5, 2013

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Starting in Microsoft Dynamics AX 2012, all tables have the TableType property that replaces the Temporary property found in Microsoft Dynamics AX 2009 and earlier versions.

The following table describes the TableType property.

Value

Description

Regular

The default value. These are permanent tables.

Temporary InMemory

A temporary table that exists as an indexed sequential access method (ISAM) file. The ISAM file can exist on either the client tier of the Application Object Server (AOS) tier. The underlying Microsoft SQL Server has no connection to the ISAM file.

The system does allow you join an InMemory table in the X++ SQL syntax. However, joins and other set operations with InMemory tables are usually inefficient.

For more information, see Temporary InMemory Tables.

An InMemory table is the same thing as what was previously called a temporary table in Microsoft Dynamics AX 2009.

Temporary TempDB

A temporary table that resides in the TempDB database of the underlying SQL Server. The nonstandard format of a TempDB table causes the table to be dropped when it is no longer in use by the current method.

Joins and other set operations on TempDB tables can be efficient.

For more information, see Temporary TempDB Tables.


Announcements: New book: "Inside Microsoft Dynamics AX 2012 R3" now available. Get your copy at the MS Press Store.

Community Additions

ADD
Show: