# TableConnectionType option type
> Version: _Available or changed with runtime version 1.0._
Use variables of this data type to specify the type of connection to an external database.
## Members
Member|Description
CRM|Specifies the table as an integration table for integrating Dynamics 365 Business Central with Dynamics 365 for Sales. The table is typically based on an entity in Dynamics 365 for Sales, such as the Accounts entity.
ExternalSQL|Specifies the table as a table or view in SQL Server that is not in the Dynamics 365 Business Central database.
Exchange|This is for internal use only.
MicrosoftGraph|This is for internal use only.
## Related information
Get Started with AL<../../devenv-get-started>
Developing Extensions<../../devenv-dev-overview>

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/methods-auto/tableconnectiontype/tableconnectiontype-option, 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/methods-auto/tableconnectiontype/tableconnectiontype-option/
