Thanks No, but I only want a ddl to extract a contraints and all its dependants, I think there must be one tested somewhere , but the problem is I can't find it. I don't want something to get all the ddls. Only the specific to one constraint. I'm busy and want to save time. Juan Carlos Reyes Pacheco OCP -------Original Message------- From: Post, Ethan Date: 12/17/04 12:05:41 To: jreyes@xxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: RE: Script to get ddl from constraints (and its dependants ) including foreign keys to recreate did you try ddlwizard? -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Juan Carlos Reyes Pacheco Sent: Friday, December 17, 2004 9:37 AM To: oracle-l@xxxxxxxxxxxxx Subject: Script to get ddl from constraints (and its dependants ) including foreign keys to recreate 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 -- //www.freelists.org/webpage/oracle-l