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.