I see that in derby if a table is being referenced in a view, we need to drop the view first and then only we can drop the table being referenced in a view. But in DB2, we do allow users to drop the table and we mark the view invalid. So just wondering why we don't the same in Derby and are there any plans of doing so soon?

This issue is relevant, though not identical:

https://issues.apache.org/jira/browse/DERBY-2098

I don't think anyone is actively working in this area right now.
If you are interested, perhaps you could get involved and contribute
an implementation?

thanks,

bryan

Reply via email to