Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
DROP EXTERNAL DATA SOURCE (Transact-SQL)
Applies to: 👁 Image
SQL Server 2016 (13.x) and later versions 👁 Image
Azure SQL Database 👁 Image
Azure SQL Managed Instance 👁 Image
Azure Synapse Analytics 👁 Image
Analytics Platform System (PDW)
Removes an external data source used for PolyBase and data virtualization features.
👁 Image
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;
Related content
Feedback
Was this page helpful?