— cons_lst.sql
— mdw 7/97 – simple list of constraints on a table
set pause on
set pages 24
set pause ‘Any Key>’
spool cons_lst.lst
select owner
,table_name    tab_nam
,constraint_type  const_type
,constraint_name  const_name
from all_constraints
where table_name like upper(‘&tab_name’||’%’)
and constraint_name not like ‘SYS%’
/
spool off