Unable to drop schema in derby

Question

Here as you can see I have a schema with name MySchema

But now I wanted to delete it

But it is not working and showing me the error saying "Encountered EOF" :

How could I delete this schema?

Using java-8, netbeans-8, and execution was being made using Client driver i.e. org.apache.derby.jdbc.ClientDriver

Answer 1

You need to add the restrict keyword to the end of your command, e.g.

drop schema myschema restrict;

This enforces the rule that no objects can be defined in the schema when it is to be deleted.