Paste -> Structure and Data

Copy the Table

Before you begin, make a COPY of the Movies table. Save this copy as a backup in case the next query eats the records. When you paste the table, you will be offered several options.

 

Structure Only: Pastes all of the fields and the field properties. The table does not include any data. The AutoNumber begins at 1.

 

Structure and Data: Pastes everything, including all of the records.

 

Append Data to Existing Table: This paste option adds new records to an existing table.

 

Try it: Make a Copy of a Table

Open the Navigation pane.

Select: tblMovieTitles.

 

Right click to Copy and Paste this table.

Paste Table As: Structure and Data.