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.