DROP EXTERNAL DATA SOURCE (Transact-SQL)

Applies to: SQL Server 2016 (13.x) and later Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

Removes a PolyBase external data source.

Syntax

syntaxsql

-- Drop an external data source  
DROP EXTERNAL DATA SOURCE external_data_source_name  
[;]

external_data_source_name
The name of the external data source to drop.

To view a list of external data sources use the sys.external_data_sources system view.

SQL

SELECT * FROM sys.external_data_sources;

Requires ALTER ANY EXTERNAL DATA SOURCE.

Takes a shared lock on the external data source object.

Dropping an external data source does not remove the external data.

SQL

DROP EXTERNAL DATA SOURCE mydatasource;