U may try out the below :
1. Open the SQL view window.
2. Type SELECT * and press Enter. This statement will select all the columns from the table you want to copy
3. Type INTO and the name you want to give the new table.
NOTE : For eg, INTO NewTable. This statement will make sure that the copied columns are placed into the new table.
4. Now Press Enter
5. Type FROM & the name of the table you want to copy.
NOTE: For eg., FROM anytable (Old one)
Now run the query !
Last Wiki Answer Submitted: November 8, 2010 4:35 am by Subhendu Sen22,035 pts.