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?