Hi, I had been RTFM some hours, and I can find a script to change a constraint this is get the constraint ddl and all the constraints using that constraint Using dbms_metadata I couldn't get foreign keys ddl, I don't know if some one could help. Thanks. Juan Carlos Reyes Pacheco OCP -- //www.freelists.org/webpage/oracle-l