Drop Schema (SQL)

Used to remove the entire schema.

DROP SCHEMA COMPANY;

Dropped only if no elements in schema:

DROP SCHEMA COMPANY RESTRICT;

All tables, views, and constraints dropped:

DROP SCHEMA COMPANY CASCADE;