drop-external-data-source-transact-sql.md

title	DROP EXTERNAL DATA SOURCE (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
dev_langs	TSQL
ms.assetid	3f65a2f5-a6c6-4be5-8ca4-6057078fe10e
caps.latest.revision	14
author	barbkess
ms.author	barbkess
manager	jhubbard

DROP EXTERNAL DATA SOURCE (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2016-xxxx-asdw-pdw_md]

Removes a PolyBase external data source.

Transact-SQL Syntax Conventions

Syntax

-- Syntax for SQL Server, Azure SQL Data Warehouse, Parallel Data Warehouse  
  
-- 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.

General Remarks

Dropping an external data source does not remove the external data.

Examples

A. Using basic syntax

DROP EXTERNAL DATA SOURCE mydatasource;  

Examples: [!INCLUDEssSDWfull] and [!INCLUDEssPDW]

B. Using basic syntax

DROP EXTERNAL DATA SOURCE mydatasource;  

See Also

CREATE EXTERNAL DATA SOURCE (Transact-SQL)