TableType Property
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:
- Setting "SourceTableTemporary" on all pages that use the table. See SourceTableTemporary Property.
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.