Jaa


Tables in Microsoft Dynamics NAV

Tables are the fundamental objects in any database. They are the objects in which you store and manipulate data. This is true no matter what kind of data you need to manage. When you create a new database, you begin by building the tables. Later, you create pages and reports in order to access and view the data in the tables.

The following sections provide an overview of how to locate Help about designing tables in Dynamics NAV.

Creating Tables

This section explains how to design tables to store your data and set up table descriptions that can ease sophisticated data manipulation.

To See
Learn about the Dynamics NAV approach to tables in database design. Overview of Tables
Design and develop a basic table in Dynamics NAV. How to: Create a Table
Decide which field data type to apply to your data. Field Data Types and Data Format Considerations
Apply table and field properties and create effective table descriptions. How to: View or Modify Properties on a Table or Field
Connect table data through primary and secondary keys. Table Keys
Learn about Dynamics NAV features designed to speed up data manipulation and computation. Accessing Microsoft Dynamics NAV Tables with External Tools

Using Triggers in Database Design

Dynamics NAV supports setting up actions to take place in response to specific events. These are known as triggers. The following topics help to explain how Dynamics NAV implements this feature of database design.

To See
Learn about the set of triggers that Dynamics NAV supports for tables and fields. Table and Field Triggers
Create a table trigger. How to: Define or Modify Table or Field Triggers
See reference information about specific triggers. Triggers

Designing Relationships Between Tables

In Dynamics NAV, the primary way to establish a connection between tables is to use the TableRelation property. The following topics go into detail about how this works.

To See
Get a brief introduction to relational database design in Dynamics NAV. Setting Relationships Between Tables
Understand the extra steps SQL Server requires to use the TableRelation property. Maintaining Table Relationships on SQL Server

Understanding SQL Server and Linked Objects

Dynamics NAV supports special handling for SQL Server Object tables. You can find help on linked objects in the following topics.

To See
Learn about the LinkedObject table property. Creating Table Definitions from SQL Server Objects (Linked Objects)
Work with other data sources, including Microsoft Excel and Oracle databases. Accessing Objects in Other Databases or on Linked Servers

See Also

Special Tables
Development