Have not tried ddl wizard but I would think it might have an option to specify what you want extracted right? Have you checked it out? -----Original Message----- From: Juan Carlos Reyes Pacheco [mailto:jreyes@xxxxxxxxxxxxxxxx]=20 Sent: Friday, December 17, 2004 10:09 AM To: Post, Ethan; oracle-l@xxxxxxxxxxxxx Subject: RE: Script to get ddl from constraints (and its dependants ) including foreign keys to recreate 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. =20 Juan Carlos Reyes Pacheco OCP -- //www.freelists.org/webpage/oracle-l