| title | DROP EXTERNAL FILE FORMAT (Transact-SQL) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/07/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 | 8cf9009b-59f9-4aac-bef1-dcf2cf0708b2 | |
| 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 file format.
Transact-SQL Syntax Conventions
-- Drop an external file format
DROP EXTERNAL FILE FORMAT external_file_format_name
[;]
external_file_format_name
The name of the external file format to drop.
To view a list of external file formats use the sys.external_file_formats (Transact-SQL) system view.
SELECT * FROM sys.external_file_formats;
Requires ALTER ANY EXTERNAL FILE FORMAT.
Dropping an external file format does not remove the external data.
Takes a shared lock on the external file format object.
DROP EXTERNAL FILE FORMAT myfileformat;