Database schema for Navision

Dynamics 365 Business Central/NAV User Forum
1

Hi,

One of our customer is asking for

Database schema for Navision tables with their relations.

Where can I find this?

Thanks in advance

Thomas

2

Maybe following the path: file>>database>>information. From here you will get details about your tables and much to do with your database.

3

Its not available, and even if it was it really would not help them.

4

You could try to draw it using a tool, such has SQL Server Management. Has has David said it’s almost useless without knowing NAV business logic.

5

Make sure you have enabled the Maintain Relationships option in the File → Database → Alter Database → Integration tab if you want to draw it from SQL Server. Try to generate the tables that you need only. Do not generate all tables at one shot. It will takes too long to generate all tables.