Using the current version of Sql Developer Data Modeler (4.1.3) when I build a model that includes a few views with primary key constraints and the Drop Selection selected for Views, it does NOT include the CASCADE CONSTRAINTS in the drop statement.
Is there a way to have this done or can it be added as a feature in the future?
Sample portion of script build from data model:
-- Generated by Oracle SQL Developer Data Modeler 4.1.3.901
-- at: 2016-01-21 11:57:04 MST
-- site: Oracle Database 11g
-- type: Oracle Database 11g
DROP VIEW XXRE_PROJECTS_ALL_V
;
DROP VIEW xxre_expenditure_types_v
;
DROP VIEW xxre_orgs_v
;
DROP VIEW xxre_tasks_v
;
DROP TABLE Allocation_Method CASCADE CONSTRAINTS ;
DROP TABLE Cost_Frequency CASCADE CONSTRAINTS ;
DROP TABLE Unit_of_Measure CASCADE CONSTRAINTS ;
Notice that the DROP for tables includes the CASCADE CONSTRAINTS but the VIEW does NOT..
Thank you,
Tony Miller
Los Alamos, NM