I am a new OraDev Studio user (v2.55.167), so perhaps I'm missing something, but I don't see a way to examine or modify foreign key (referential integrity) constraints on VIEWS. For me this is a pretty big issue. I've searched both the help and the forum, to no avail.
Both Toad and Oracle SQL Developer do provide a way to view these constraints on Views.
What am I missing?
Interesting Note: when you ask Oracle SQL Developer to display the SQL of a view, the display includes the statements that define the constraints but not those that define view and column comments. OraDev Studio shows the comment statements but not the constraint statements. Go figure ...
support for Foreign key constraints on VIEWS
-
- Posts: 3
- Joined: Wed 21 Jul 2010 12:56
-
- Posts: 3
- Joined: Wed 21 Jul 2010 12:56
Thank you again for the response. Please put the ability to at least examine column constraints of views on the OraDeveloper feature "wish list". I can't uninstall Toad until I can see view constraints in OraDeveloper Studio!
It would be excellent if OraDev could simply add the DDL statements for the constraints to the display in the Text tab of the view editor.
It would be excellent if OraDev could simply add the DDL statements for the constraints to the display in the Text tab of the view editor.