Re: Help with sql identifying dup constraints

  • From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 09 Jun 2004 23:15:28 +0200

Hi Barbara,

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)
===


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 06-2004