DROP SOURCE command to remove a source if you no longer need the data inflow from the source.
Before you can remove a source, you must use DROP MATERIALIZED VIEW to remove all its dependent materialized views.
DROP SOURCE [schema_name.]source_name;
|schema_name||The schema of the source that you want to remove. You can use |
|source_name||The name of the source to remove.|
This statement removes the "rw_source" source in the default schema ("public") from the database:
DROP SOURCE rw_source;
This statement removes the "rw_source" source in the "rw_schema" schema from the database:
DROP SOURCE rw_schema.rw_source;