Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server 2016 (13.x) and later
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
Removes an external data source used for PolyBase and data virtualization features.
Transact-SQL syntax conventions
Syntax
-- Drop an external data source
DROP EXTERNAL DATA SOURCE external_data_source_name
[;]
Arguments
external_data_source_name
The name of the external data source to drop.
Metadata
To view a list of external data sources, use the sys.external_data_sources system view.
SELECT * FROM sys.external_data_sources;
Permissions
Requires ALTER ANY EXTERNAL DATA SOURCE.
Locking
Takes a shared lock on the external data source object.
Remarks
Dropping an external data source does not remove the external data.
Examples
A. Use basic syntax
DROP EXTERNAL DATA SOURCE mydatasource;