Tuesday, August 21, 2012

AX 2012 Database Temp Table

From MSDN:

...One type of temporary table is a TempDB table. They are called TempDB tables since the TableType property value is TempDB (TableType::TempDB). The TableType property value can be set from AOT > Data Dictionary > Tables > MyTempDBTable > Properties > TableType.

All types of temporary tables are automatically dropped by the system when the table variable in X++ goes out of scope. A TempDB table is not dropped when you set its record buffer variable to null.

TempDB tables are a different type of temporary table than InMemory tables. For more information, see Temporary InMemory Tables.

For more info:

No comments:

Post a Comment