Get table name from tableid Dynamics AX 2012 / AX 2009

In Microsoft Dynamics AX, many time during development it requires to get the table name from the table id or visa versa. Here is the code to Get table name form the table id in Dynamics AX 2009 / AX 2012.

static void GetTableName(Args _args)

{

        info(tableid2name(2438));

}

If you find this helpful, write in the comments below or like.

Get table name from the TableId for Dynamics AX 2012 through SQL

In Microsoft Dynamics AX many time during development it requires to get the table name from the table id or vis versa. 

here is the query to Get table name form the table id in dynamics AX 2012.



Get table name from the TableId for Dynamics AX 2012 through SQL

Select Name
From SQLDICTIONARY
Where tableId = 505
         and FieldId=0


Get table ID from the Table Name for Dynamics AX 2012 through SQL

Select TableId
From SQLDICTIONARY
Where Name = 'HcmWorker'
         and FieldId=0


If you find this helpful, write in the comments below or like.