I think that Derby currently does not support a CASCADE option on the DROP TABLE statement.
I searched Jira and found DERBY-1631, which discusses the desire for a CASCADE option on DROP VIEW, but I could not find a Jira issue logged to request a CASCADE option on DROP TABLE. Is there such a Jira entry already logged? If not, should I log one? thanks, bryan