Share via


TableType Property

Specifies the table type.

Applies To

  • Tables

Property Value

Value Description

Normal

Specifies the table as a normal table in the Microsoft Dynamics NAV database. This is the default value.

CRM

Specifies the table as an integration table for integrating Microsoft Dynamics NAV with Microsoft Dynamics CRM. The table is typically based on an entity in Microsoft Dynamics CRM, such as the Accounts entity.

ExternalSQL

Specifies the table as a table or view in SQL Server that is not in the Microsoft Dynamics NAV database.

Remarks

Tables that are marked as CRM or ExternalSQL are considered to external tables that are not managed by Microsoft Dynamics NAV. These tables use a different SQL Server connection than the normal tables in the Microsoft Dynamics NAV database. For more information, see External Tables.

Important

We advise against creating tables of type CRM manually. Instead, use the integration mapping functionality. For more information, see Integration Concepts and Terminology.

See Also

Reference

Table Designer

Concepts

External Tables
Properties