Foreign keys in Microsoft Dynamics NAV 5

Hi there,

I am in the business of extracting data from several accounting tools so they can be represented in our software tools. Right now I am working on a Navision (what we call a) collector.

In order to understand form which tables all the required data has to be gathered I started creating database diagrams. To my surprise all tables were shown but no connections (Foreign keys) between them. The query


xtype, COUNT(xtype) FROM sys.sysobjects GROUP BY xtype

taught me that there were no Foreign keys!
How can this be? Is this correct?


This has been discussed plenty of times before. Try searching or using Google.