#1083 Copy field structure to another table



Today i realised i needed a function to copy entire structure of selected fields from one table to another.

If i should make some kind of backup table but with additional fields. I could just create the new table with the additional fields and then copy selected fields from the main table to the backup table.

Or if you are using some generic fields as; status, creation timestamp etc etc. it would be great to copy them from one table to another.
And also a functionality to select what field the fields should be inserted after.


  • Olaf van der Spek

    Logged In: YES
    Originator: NO

    Export structure
    Use notepad to add/delete fields
    SQL - Create tables?

  • Marc Delisle

    Marc Delisle - 2008-08-17

    Logged In: YES
    Originator: NO

    Yes, I also think that this is a request too specific that can be done with other techniques.

  • Marc Delisle

    Marc Delisle - 2008-08-17
    • assigned_to: nobody --> lem9
    • status: open --> pending
  • SourceForge Robot

    Logged In: YES
    Originator: NO

    This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 14 days (the time period specified by
    the administrator of this Tracker).

  • SourceForge Robot

    • status: pending --> closed
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed --> fixed

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks