On 1/10/15 8:38 PM, zhosn wrote:
Hi，Bryan ：
I not create table,view etc.When i create schema,Only created a
schema.when i run script"DROP SCHEMA schemaName RESTRICT"System tip:no
drop,Why? and Derby no support keyword"cascade".
--
View this message in context:
http://apache-database.10148.n7.nabble.com/drop-schema-question-tp143576p143578.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
I am unable to reproduce the result you are seeing. The following script
runs cleanly for me:
connect 'jdbc:derby:memory:db;create=true';
create schema foo;
drop schema foo restrict;
Concerning DROP SCHEMA CASCADE: You are welcome to work on this feature:
https://issues.apache.org/jira/browse/DERBY-4029. I think that most of
the code has already been written. That code is part of the cleanup
logic called by Derby's JUnit test cases.
Hope this helps,
-Rick
