Temp Table pros and cons - Dynamcis AX

Most of the time we require Temp Tables in our solution. This post is about temp table's capabilities, limitations and life-cycle.

When we use temp tables, axapta kernel creates a table in SQL temp database with a different name.

Capabilities:

• Can be joined with normal tables in X++
• Can save Data Per Company
• Can be used in Enterprise Portal development
• Can have foreign keys from other tables
• Can have Indexes

Limitations:

• Cannot be a Valid Time State Table
• Cannot have Delete Action
• No Record Level Security (RLS)
• No View support (cannot be used in views)

Life-Cycle: When is temp table dropped from TempDB?

• Table buffer goes out of scope
• Restart of AOS service
• Restart of SQL service
• Closure of AX32.exe

Hope it helps !!!

Difference between Refresh AOD, Refresh Data, Refresh dictionary on enterprise portal - Dynamics AX 2012

While development of Enterprise portal you might need to use following options:

Refresh AOD: This refreshes all the AOT elements except  elements in Data Dictionary node for example classes, data sets web menu items etc.

Refresh Data: Refreshes any static data that is used on enterprise portal sessions.

Refresh Dictionary: Refreshes the elements contained in Data Dictionary node of AOT for example tables, EDT, enums, views etc.