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 if the owner does not own some objects in the schema.
- In the Object List Viewer, right-click the schema you want to drop and select Drop.
- Click OK to confirm the drop operation.