Drop Table
DROP TABLE
Usage
SQL
DROP TABLE <dwh_schema_name>.<table_name> ;;
DROP TABLE <datasource_name>.<table_name> ;;Examples
1. Dropping a table in the dwh schema:
SQL
DROP TABLE dwh.test_table ;;2. Dropping table in a data source:
SQL
DROP TABLE test_tables_pg.test_table_ds ;;DROP TABLE IF EXISTS
Usage
SQL
DROP TABLE IF EXISTS <dwh_schema_name>.<table_name> ;; DROP TABLE IF EXISTS <datasource_name>.<table_name> ;;No warning will appear if this procedure does not exist; the Server will quietly execute it.
Examples
1. Dropping a table in the dwh schema:
SQL
DROP TABLE if exists "dwh.testtable2" ;;2. Dropping a table in a data source:
SQL
DROP TABLE if exists test_tables_pg.test_table_ds ;;