Removes a PolyBase external data source.
Transact-SQL Syntax Conventions
-- 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.
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.
DROP EXTERNAL DATA SOURCE mydatasource;