Hi All
how do i know / check Dynamics 365 FO database schema or metadata information where i can understand relationship between entities or i can create new relationship ?
Reggards
I wouldn't say that functional consultant can do everything. It's true that a lot can be achieved by configuration (especially with PowerApps) but I wouldn't bet any money on D365FO development disappearing any time soon. They are two different toolsets. And no matter if it's configuration or development, designing your solution well is the challenge, not using the tools.
About table fields, it's very limited what you can do when you add them via configuration. You can only add them to master data tables, you can't use them on reports etc.
Thanks reverse engineering option good . As per my understanding Microsoft minimise technical role in D365 that’s why might be in coming year only Functional consultant can do everything. Even now table fields can create from user interface . Am I right ? Please add your comments about this changing technical to functional thanks
You can find table relation definitions in AOT in Visual Studio, on a D365FO development system. And you can also develop new tables and define relations with Visual Studio.
Hi MRizwan,
For Dynamics AX 2012 R2, Microsoft created an ERD page with information. This was never updated and Microsoft retired the site. In parallel, they put the old information on GitHub. Alex Meyer (another MVP), did put the information on his personal blog: alexdmeyer.com/.../
Some parts are still valid for Dynamics 365, but there are already a lot of changes. So, the information can be outdated. There is no updated information provided by Microsoft. In that case, you have to create your own schemas, based on reverse engineering.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sohaib Cheema 785 User Group Leader
André Arnaud de Cal... 626 Super User 2025 Season 2
Martin Dráb 621 Most Valuable Professional
