Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

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

Posted on by 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 230,198 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans