Copy A Table Into The Same Database

[PC Datasheet]

How do you copy a table into the same database and give it a new name? For
example, copy "MyTable" and give the copy the name "MyNewTable".

Thanks,

Steve

[bcanavan]

Create a "make table" query:

Open a new query in the query designer.

Drag your source table into the top half of the designer.

Drag all the fields you like from the old table def to the query grid.

If necessary, set your filters and sorting to taste and run it.

Run as a SELECT query first to be sure you like the results.

Change the query (using the tool on the toolbar) to a Make-Table query,
and enter the new table name.

Run it.

You'll still have to define primary key and indexes, if any, in the
table manually.

Don't forget to set permissions on the new table before deploying for
other users.

Bob

[bob_orta]

If you want an exact duplicate and are not doing this with code, select
the table and do ctrl-C then a ctrl-V and give the table a name.

Bob

[bcanavan]

Even better! Thanks, Bob!

[bcanavan]

Even better! Thanks, Bob!