Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to get table names...
Finance | Project Operations, Human Resources, ...
Answered

How to get table names, IDs... from inheritanced tables

(0) ShareShare
ReportReport
Posted on by Sayid 75

Hello,

I have list of many table IDs in AX12 and I need to get their table aot names... For "normal" tables it is OK, I can get it using SQL from SQLDICTIONARY table, but if the table "B" is inherited from some other table "A", there are fields from table "B" under table "A". But under table "A" are only fields, the problem is I would also need to know, where are stored the table names, table IDs of inherited tables. As I have been told, it should be stored somewhere, but I have no idea where. 

Thanks

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 233,013 Most Valuable Professional on at
    RE: How to get table names, IDs... from inheritanced tables

    This information doesn't exist in the normal AX database. You would be much better off if you used the right way - the AX application. If you bypass the whole application and connect to the storage directly, you can get into a lot of troubles, as I mentioned in your previous thread.

    The key problem is that there is nothing like table "B" in the database. "B" is an application-layer object, while you're looking into the database layer. You should decide whether you want to work with database-layer objects, or application-layer objects, and then the best approach is doing it at the right layer.

    Didn't you consider using something like the metadata service to get information about application objects, and then use this information for your DB queries?

    Anyway, there should be a way if you insist of using a database, but you'll need to look to a different one: the modelstore database.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,013 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans