Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Modeler does NOT add CASCADE CONSTRAINTS when dropping Views

TexasApexDeveloperJan 21 2016 — edited Jan 22 2016

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

This post has been answered by David Last-Oracle on Jan 22 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2016
Added on Jan 21 2016
2 comments
441 views