Hi Marco
its this one
select constraint_name, column_name from sys.all_cons_columns
where owner = :owner and table_name = :table_name
and constraint_name not like 'SYS_C%'
order by constraint_name, position
it fires once per table. (as you know)
thanks in advance
Ruud
Last edited by Ruudbern; 10/21/14 06:48 AM.