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 !!!