Dropping a Schema in Greenplum

Use the DROP SCHEMA command to drop (delete) a schema. For example:

=> DROP SCHEMA myschema;

By default, the schema must be empty before you can drop it. If you want to drop a schema and all of the objects in that schema (tables, data, functions, etc.) use:

=> DROP SCHEMA myschema CASCADE;


Comments