Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Hi All,I would like to access/see the backend tables along with the relationship with other tables in NAV. Ideally an ERD (Entity Relationship Diagram) would be great, is there a way I can do this using the Navigator interface or SQL Server/SSMS?
Background: I am trying to mimic pre existing Jet Reports and for that it is important for me to understand the tables and mappings. I have access to SQL server database, but there are thousands of tables and it is almost impossible to go thru each table.Any help is much appreciated!!
Good question and one we do get asked now and then. However, NAV has +1400 tables that are all connected in one way or the other, and also some relations are to different tables depending on conditions. Many relationships are defined in C/AL code. In the past there has been some different tools like Navision Developers Toolkit, but at the moment there are no tools that I know off. If there was, then also the diagram would be an enormous web of 1400 tables connected depending on setup (is MRP / HR / SCM / etc used).
So, in short, sorry there is no tool like this at the moment, unless some partners know otherwise, then please share here.
Business Applications communities