By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,483 Members | 1,744 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,483 IT Pros & Developers. It's quick & easy.

Copy A Table Into The Same Database

P: n/a
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".


Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies

P: n/a
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.


Nov 13 '05 #2

P: n/a
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.


Nov 13 '05 #3

P: n/a
Even better! Thanks, Bob!

Nov 13 '05 #4

P: n/a
Even better! Thanks, Bob!

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.