Modifier

TableType Property

  • Article

Version: Available or changed with runtime version 1.0.

Specifies the table type.

Applies to

  • Table

Property Value

Value Available or changed with Description
Normal runtime version 1.0 Specifies the table type used for Dynamics 365 Business Central.
CRM runtime version 1.0 Specifies the table as an integration table for integrating Dynamics 365 Business Central with Dynamics 365 Apps.
ExternalSQL runtime version 1.0 Specifies 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.
Exchange runtime version 1.0 This table type is not supported in Business Central online.
MicrosoftGraph runtime version 1.0 This table type is not supported in Business Central online.
CDS runtime version 5.0 Specifies the table as an integration table for integrating Dynamics 365 Business Central with Dynamics 365 Apps.
Temporary runtime version 6.0 Specifies 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.

See Also

Properties
SourceTableTemporary Property