Removes the specified file format from the current/specified schema.
CREATE FILE FORMAT , ALTER FILE FORMAT , SHOW FILE FORMATS , DESCRIBE FILE FORMAT
DROP FILE FORMAT [ IF EXISTS ] <name>
Copy
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.
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.
When the IF EXISTS clause is specified and the target object doesn’t exist, the command completes successfully without returning an error.
DROP FILE FORMAT my_format; ---------------------------------+ status | ---------------------------------+ MY_FORMAT successfully dropped. | ---------------------------------+Copy
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4