DROP statements are used to remove a registered table/view/function from current or specified Catalog.
Flink SQL supports the following DROP statements for now:
Run a DROP statement
DROP statements can be executed with the sqlUpdate() method of the TableEnvironment, or executed in SQL CLI. The sqlUpdate() method returns nothing for a successful DROP operation, otherwise will throw an exception.
The following examples show how to run a DROP statement in TableEnvironment and in SQL CLI.
Drop a table with the given table name. If the table to drop does not exist, an exception is thrown.
If the table does not exist, nothing happens.
Drop a database with the given database name. If the database to drop does not exist, an exception is thrown.
If the database does not exist, nothing happens.
Dropping a non-empty database triggers an exception. Enabled by default.
Dropping a non-empty database also drops all associated tables and functions.
Drop a catalog function that has catalog and database namespaces. If the function to drop does not exist, an exception is thrown.
Drop temporary catalog function that has catalog and database namespaces.
Drop temporary system function that has no namespace.