| title | DROP EXTERNAL DATA SOURCE (Transact-SQL) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/03/2017 | |
| ms.prod | sql | |
| ms.prod_service | sql-data-warehouse, pdw, sql-database | |
| ms.reviewer | ||
| ms.technology | t-sql | |
| ms.topic | language-reference | |
| dev_langs |
|
|
| ms.assetid | 3f65a2f5-a6c6-4be5-8ca4-6057078fe10e | |
| author | CarlRabeler | |
| ms.author | carlrab | |
| monikerRange | >=aps-pdw-2016||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDE sqlserver2016-asdbmi-asa-pdw]
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;