select table_name
, constraint_name
, constraint_type,
, search_condition
, generated
from user_constraints
where generated = 'USER NAME '
and constraint_name like 'SYS_C% '
order by table_name, constraint_name
/
might give you a good set to start with.
Regards, Carel-Jan
===
If you think education is expensive, try ignorance. (Derek Bok)
===
<html >
<body >
<font size=3 >Hi Barbara, <br > <br >
select table_name <br >
, constraint_name <br >
, constraint_type, <br >
, search_condition <br >
, generated <br >
from user_constraints <br >
where generated = 'USER NAME ' <br >
and constraint_name like 'SYS_C% ' <br >
order by table_name, constraint_name <br >
/ <br > <br >
might give you a good set to start with. <br > <br >
Regards, Carel-Jan <br > <br >
=== <br >
If you think education is expensive, try ignorance. (Derek Bok) <br >
=== <br > <br >
<br >
</font > </body >
</html >
