Claus Pedersen
Member³
We have many views with a primary key. This is necessary in order to make the Microsoft entity framework for C# (supplied by Oracle) work with views.
But in PLD, these primary keys can not be seen.
When viewing the view, nothing else than the view definition itself is shown.
If you find the primary key in the Constraints part of the object browser, you can see the primary key name and the name of the involved column(s). When right-clicking on the constraint name and selecting View, a completely empty table editor is opened (despite the fact that it is a view).
For the same reason, the options Drop, Browse, and Disable/Enable do not work on view constraints (error in finding table).
Please fix this by showing the SQL code for the view constraints (primary/unique key), something like:
ALTER VIEW myView ADD CONSTRAINT myPrimaryKey PRIMARY KEY (myColumnName) RELY DISABLE NOVALIDATE;
(I am using version 10.0.3)
But in PLD, these primary keys can not be seen.
When viewing the view, nothing else than the view definition itself is shown.
If you find the primary key in the Constraints part of the object browser, you can see the primary key name and the name of the involved column(s). When right-clicking on the constraint name and selecting View, a completely empty table editor is opened (despite the fact that it is a view).
For the same reason, the options Drop, Browse, and Disable/Enable do not work on view constraints (error in finding table).
Please fix this by showing the SQL code for the view constraints (primary/unique key), something like:
ALTER VIEW myView ADD CONSTRAINT myPrimaryKey PRIMARY KEY (myColumnName) RELY DISABLE NOVALIDATE;
(I am using version 10.0.3)
