Navision Database Schema

lot

Can sombody help me of how to view the navision 2005 database schema
Thanks.

Slawek_Guzek

I have tried this once, when I have just started my NAV career. I have enabled Maintain Relationships option on the database, and asked SQL Server Managament Studio (or perhaps an Enterprise Manager) to build a schema diagram for me.

I have interrupted the process after some 8 hours. The results were completely unreadable.

The reason was that NAV was too large then. It had 700+ tables then, most with with many relations, and also a conditional relations (a thing which is not supported in SQL server)

Now standard NAV includes about 1100 tables..

Slawek

thomasbarbut

Hello,

this is for an older version.
https://drive.google.com/file/d/0B0_cco-Kvw9Cei1MY0tycGk3VjA/view

or check this thread
https://community.dynamics.com/nav/f/34/t/122994

I think the an ER-Diagram won't answer your Questions. You will have to start using Dynamics to really understand it.

best regards,
Thomas Barbut

vaprog

Also Check out @Kine's The Big Picture of NAV

kennie

Also, foreign key constraints in the Dynamics NAV database are enforced by the platform, not SQL Server. This is not helping when generating ER diagrams in SSMS