sys.external_data_sources

Description

2016 (13.x) and later versions Analytics Platform System (PDW) SQL database in Microsoft Fabric Contains a row for each external data source in the current database for SQL Server, Azure SQL Database, and Azure Synapse Analytics. Contains a row for each external data source on the server for Analytics Platform System Object ID for the external data Data source type displayed as a Data source type displayed as a

Syntax

REMOTE_DATA_ARCHIVE
4

Permissions

SQL) 06/18/2025 x) and later Removes an external data source used for PolyBase and data virtualization features. syntaxsql The name of the external data source to drop. To view a list of external data sources, use the system view. SQL Requires ALTER ANY EXTERNAL DATA SOURCE.