Please add reference constraints to table view/edit action

[S. Studeny]

Hello.

It would be great to add (maybe as separate tab) referencing constraints to the current table in Table edit/view action like per following SQL (can be modified):

select cr.*
from dba_constraints cr,
(select * from dba_constraints cx where cx.constraint_type = 'P' and cx.owner = :TAB_OWNER and cx.table_name = :TAB_NAME) cp
where cr.CONSTRAINT_TYPE = 'R'
and cr.R_OWNER = cp.owner
and cr.R_CONSTRAINT_NAME = cp.constraint_name

Thanks for considering this.

Regards,
Stanislav

 

[S. Studeny]

Also please add INVISIBLE/VISIBLE column property of 12c :

ALTER TABLE tab1 MODIFY column_a INVISIBLE;
ALTER TABLE tab1 MODIFY column_a VISIBLE;

Thanks in advance.

 

[Ivan C.]

+ 1 for the referencing constraints list as an additional tab

To get the list though, there's a workaround (sorta)...
A Table object, in Object Browser, has a sub-folder called Foreign key references. If you expand it, it shows the list of FK constraints referencing the table in focus, with the referencing table name in parenthesis.

To quickly get to the object in Object Navigator I right-click the object name in my SQL/Program/Command/etc. Window and choose Browse.