[Dark_Wizard]

Originally Posted by TheMasterG

....I need to duplicate a table in the database, basically make a copy and rename it. The data in the fields doesn't matter, just the format of the table and fields.

Any help on how to achieve this?

G

Your asking two things...one is to duplicate it and another to rename it...so I will give you some basic info on MySQL.

MySQL will allow you to rename the table which copies the table to a temp table, then creates a new table with the new name and copies the data from the temp table into the new one and finally removes the old table.

If this isn't what you need then please indicate which process you need to do.