# 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
```al
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<../../administration/operational-limits-online>, but are counted against Power Platform request limits<https://learn.microsoft.com/power-platform/admin/api-request-limits-allocations#non-licensed-user-request-limits>.
> IMPORTANT
> We advise against creating tables of type CRM/CDS manually. Instead, use the ../devenv-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 devenv-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.
See ../devenv-temporary-tables.
## Related information
devenv-properties
devenv-sourcetabletemporary-property

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-tabletype-property, MicrosoftDocs/dynamics365smb-devitpro-pb at 828b6ee (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/dev-itpro/developer/properties/devenv-tabletype-property/
