| title | DROP EXTERNAL DATA SOURCE (Transact-SQL) | |
|---|---|---|
| description | DROP EXTERNAL DATA SOURCE (Transact-SQL) | |
| author | markingmyname | |
| ms.author | maghan | |
| ms.date | 03/03/2017 | |
| ms.prod | sql | |
| ms.prod_service | synapse-analytics, pdw, sql-database | |
| ms.technology | t-sql | |
| ms.topic | reference | |
| dev_langs |
|
|
| monikerRange | >=aps-pdw-2016||=azure-sqldw-latest||>=sql-server-2016||>=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;