title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | dev_langs | monikerRange | |
---|---|---|---|---|---|---|---|---|---|---|
DROP EXTERNAL FILE FORMAT (Transact-SQL) |
DROP EXTERNAL FILE FORMAT (Transact-SQL) |
WilliamDAssafMSFT |
wiassaf |
03/07/2017 |
sql |
t-sql |
reference |
|
>=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 file format.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: 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;