Hello DBAs:

I have a production system with all constraints required on the system and want to duplicate the effort in Development system.

I am looking for a script that can extract code "alter table" statements from Production. I am looking for only Primary and Foreign key constraints and not Check and not null constraints..

I am looking into dba_constraints and dba_cons_cols to achieve this, but if anyone has more ideas, would appreciate it..

Thanks, ST2000

~