To drop a schema, you must be the owner of the schema object. The owner can drop a schema and all objects it contains even though the owner does not own some objects in the schema.
- In the Object List Viewer, select the schema you want to drop.
- Right-click the schema and click Drop, or click .
- Click OK to confirm.