Hi Team,
I want to Copy a Table's structure to a new table with a different name.  I need to include all fields, constraints & indexes.
If I use the 'Create Copy of Table' in edbmgr it only copies the table and constraints.

Is there a way?

Regards & TIA,
Ian

Ian


In EDBManager open a new sql window, drag the table to be copied over. Then open the list to show indices (constraints should be in with the table definition) and drag them over one by one. Finally expand triggers and drag them over. Change the table name throughout and you should have all the sql you need to create the new table.

Roy Lambert