TableType Property

Version: Available or changed with runtime version 1.0.

Specifies the table type.

Applies to

  • Table

Property value

ValueAvailable or changed withDescription
Normalruntime version 1.0Specifies the table type used for Dynamics 365 Business Central.
CRMruntime version 1.0Specifies the table as an integration table for integrating Dynamics 365 Business Central with Dynamics 365 Apps.
ExternalSQLruntime version 1.0Specifies the table as a table or view in SQL Server that is not in the Dynamics 365 Business Central database. This table type is not supported in Business Central online.
Exchangeruntime version 1.0This table type is not supported in Business Central online.
MicrosoftGraphruntime version 1.0This table type is not supported in Business Central online.
CDSruntime version 5.0Specifies the table as an integration table for integrating Dynamics 365 Business Central with Dynamics 365 Apps.
Temporaryruntime version 6.0Specifies the table as an in-memory table used to store temporary data.

Syntax

TableType = CDS;

Remarks

Tables that are marked as CDS or ExternalSQL are considered external tables that are not managed by Dynamics 365 Business Central. These tables use a different SQL Server connection than the normal tables in the Dynamics 365 Business Central database.

Note


Tables of types CRM and CDS are used to create outgoing service calls towards Dataverse and Dynamics 365 Apps. Such calls are not counted against Business Central API limits, but are counted against Power Platform request limits.

Important


We advise against creating tables of type CRM/CDS manually. Instead, use the AL Table Proxy Generator.

Temporary tables

Marking a table as Temporary is the same as:

Temporary tables are not synchronized with the SQL database, so they do not follow the same rules about making destructive changes.

You can change an existing table from Normal to Temporary. But the table will be deleted from the database when you synchronize the extension. If the table contains data, you'll have to use the ForceSync mode.

For more information, see Temporary Tables.

Properties
SourceTableTemporary Property