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;