Claus Pedersen
Member³
For views in the object browser, you can not see defined primary, unique, or foreign key constraints. Please enable this feature (using selects like:
select constraint_name from all_constraints where table_name = and constraint_type = 'P'
and
select column_name from all_cons_columns where constraint_name = order by position)
Note: I am not very familiar with creating my own browser folders based on e.g. data dictionary views. But can I for this purpose define my own new branch below for instance Views -> -> and then my own folder, for instance Primary key or Unique keys, like for tables? Or can I only create new folders on the top level?
select constraint_name from all_constraints where table_name = and constraint_type = 'P'
and
select column_name from all_cons_columns where constraint_name = order by position)
Note: I am not very familiar with creating my own browser folders based on e.g. data dictionary views. But can I for this purpose define my own new branch below for instance Views -> -> and then my own folder, for instance Primary key or Unique keys, like for tables? Or can I only create new folders on the top level?
