The TableRelation Property in Microsoft Dynamics NAV can be represented in SQL Server by table relationships known as foreign key constraints. These table relationships are metadata about the tables and are only intended for modeling and diagramming; they are not used to enforce data integrity. The foreign key constraints are disabled.
The table relationships in SQL Server can be accessed with external tools that can use this information to generate diagrams illustrating the structure of the database.
You can use the Maintain Relationships option on the Integration tab of the Alter Database window to enable and disable the table relationships on SQL Server. For more information, see Altering Databases - Integration Tab.
Requirements
There are certain requirements that must be met before a TableRelation Property can be represented on SQL Server.
To maintain a table relationship:
- The fields forming the relationship must be
of the same data type in both of the related tables. This also
applies to any fields that are specified in the Table Filter field.
Text and code fields are compatible as long as they have the same
length.
- The SQL
Data Type Property of code fields must be the same in both
tables.
- The table filter that is part of the table
relationship must contain only the FIELD filter type. Table filters
of the CONST and FILTER filter type cannot be created on SQL
Server.
- Conditional relationships have one SQL Server
relationship for each condition, as long as all of the criteria
listed here are met by each condition.