Since Oracle 9i we can define constraints like primary key, foreign key, unique key, check constraints on views too. It' smore or less informational for common views but used by the optimizer for query rewrite on Materialized views.
Would be fine to be able to document the constraints on views in the same manner as for tables.
btw: Do you plan to have a complete 'view editor' in the next PLSQLDev release including comments, constraints, MView support? If so, I wouldn't spend more effort in my selfmade plugin.
Would be fine to be able to document the constraints on views in the same manner as for tables.
btw: Do you plan to have a complete 'view editor' in the next PLSQLDev release including comments, constraints, MView support? If so, I wouldn't spend more effort in my selfmade plugin.
