number of temp table and their name by a job or x++???

Dynamics 365 for Finance and Operations/AX Technical Forum
1

Hi Guys i followed this link www.kaya-consulting.com/…/ i was trying to create a role and I am not able to figure out the tmp tables there… is there any way we can find the temp tables and their name in AOT by a job or x++???

2

Hi Rohit,

Execute this job to find the In memory tables in AX. The execution takes bit time to list.!!

static void TmpTablesList(Args _args)
{
DictTable dictTable;
Dictionary dict = new Dictionary();
int i;
container names;
#ResAppl

for (i=1; i<=dict.tableCnt(); i++)
{
dictTable = new DictTable(dict.tableCnt2Id(i));
if ( dictTable.isTmp())
{
names += dictTable.name();
}

}
conView(names);
}

Regards,

Raghav.