How to know which tables to look for in MSQL-DB

Finance and Operations/AX Technical Forum
1

Hi, I need to find certain tables in the MSQL-Database for OLAP purposes. By clicking on “record info” in Axapta, I get the number of the table, but not the name. Is there a way to look up the name of the table? Thanks, Nils

2

Hi Nils, You might want to try ‘TableId2Name’ function available under AOT → System Documentation → Functions. Regards, Harish Mohanbabu

3

Hello Nils, If you are not a developer then the following report may help: - Administrator/Company Accounts/Reports/Company Account Relations Regards, Andrew Cowell

4

Hi Andrew, you’re right, Administration/Company Accounts/Tables does it. Thank you for your help :slight_smile: Regards, Nils