How many types of keys in Navision

Question

Accepted Answer

There are three types of keys in Navision: Primary Key, Foreign Key, and Unique Key.

Primary Key: A primary key is a unique identifier for a record in a table. It ensures that each record is unique and can be used to establish relationships with other tables.
Foreign Key: A foreign key is a field in a table that refers to the primary key of another table. It establishes a relationship between two tables.
Unique Key: A unique key ensures that the values in a specific field or combination of fields are unique within a table. It can be used to enforce data integrity and prevent duplicate values.

Accepted Answer

In Microsoft Dynamics NAV (formerly Navision), there are four main types of keys that can be defined for a table:

Primary key: A primary key is a unique key that identifies each record in the table. Every table in NAV must have a primary key, and it must consist of one or more fields. The primary key is used to enforce data integrity, and to ensure that each record can be uniquely identified.
Foreign key: A foreign key is a key that is used to link two tables together. A foreign key in one table refers to the primary key in another table. The foreign key is used to maintain referential integrity, which means that a record in the referencing table cannot be inserted or updated unless the referenced record exists in the referenced table.
Unique key: A unique key is a key that ensures that no two records in the table have the same values in the fields that make up the unique key. Unlike the primary key, a table can have multiple unique keys. Unique keys are often used to enforce business rules, or to ensure that certain fields are unique.
Normal key: A normal key is a non-unique index that is used to improve the performance of queries on a table. A normal key can be defined on one or more fields, and it can be used to speed up queries that use those fields in the WHERE clause.

In addition to these four key types, there are also composite keys, which are keys that consist of more than one field. Composite keys can be defined as primary keys, foreign keys, unique keys, or normal keys. Composite keys are often used to enforce complex business rules or to improve performance of queries that involve multiple fields.

How many types of keys in Navision

Top CorporateServe Solution Navision Technical Consultant interview questions & answers