Microsoft Dynamics AX (Archived)

List of All Table with ID, Name and Label

(0) Share

Report

Posted on by Community Member

Can anyone help me to retrieve the list of all tables in ax 2009 with ID, Name and Label

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
yeah you can get list as following

static void ListOfTables(Args _args) { UtilElements localEelmet; UtilEntryLevel LayerName = UtilEntryLevel::usr; TreeNode treeNode; ; while select localEelmet where localEelmet.utilLevel == LayerName && localEelmet.recordType == UtilElementType::Table { treeNode = xUtilElements::getNodeInTree(xUtilElements::parentElement(localEelmet)); info(strFmt("TableId: %1 ; Name: %2",localEelmet.TableId,localEelmet.name)); } }

But remember, running job can take long time, so better to use progress bar and save this information somewhere in new table or on any report.

Also don't forget to change/remove Layer range in query, as per your own need

Was this reply helpful? Yes No
Suggested answer

Rudi Hansen 4,079 on at

Like (1)

Report
Copy link

Link copied!
This job should do the trick.

static void TableList(Args _args) { tableId tableId; int tablecounter; Dictionary dict = new Dictionary(); for (tablecounter=1; tablecounter<=dict.tableCnt(); tablecounter++) { tableId = dict.tableCnt2Id(tablecounter); info(strFmt("TableId: %1 ; Name: %2 ; Lable: %3",tableId,tableid2name(tableId),tableid2pname(tableId))); } }

Was this reply helpful? Yes No
karthickarden 135 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I want to get the custom tables list from Dynamics AX 2009 through C#.

Could you please provide the sample code

Thanks

Was this reply helpful? Yes No
Martin Dráb 239,029 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You already have X++ code doing that.

Use Business Connector to call X++ code AX 2009 from C#.

Was this reply helpful? Yes No