Categories:

Data Loading / Unloading DDL

DROP FILE FORMAT

Removes the specified file format from the current/specified schema.

See also:

CREATE FILE FORMAT , SHOW FILE FORMATS

Syntax

DROP FILE FORMAT [ IF EXISTS ] <name>

Parameters

name

Specifies the identifier for the file format to drop. If the identifier contains spaces, special characters, or mixed-case characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

Usage Notes

  • Dropped file formats cannot be recovered; they must be recreated.

  • Dropping a file format that is referenced in another object (e.g. named stage) does not cause errors because the object uses the file format defaults in place of the dropped file format.

Examples

DROP FILE FORMAT my_format;

---------------------------------+
           status                |
---------------------------------+
MY_FORMAT successfully dropped.  |
---------------------------------+