copyTable( )

Topic group Related topics

Makes a copy of one table to create another table in the same database.

Syntax

<oRef>.copyTable(<source table expC>, <destination table expC>)

<oRef>

The database in which you want to copy the table.

<source table expC>

The name of the table you want to duplicate.

<destination table expC>

The name of the table you want to create.

Property of

Database

Description

copyTable( ) copies all of the rows from a single table in a database to another new table in the same database. The resulting destination table will be the same table type as the source table. Use the UpdateSet’s copy( ) method for any other type of row copy.

The table to copy should not be open.

To make a copy of a Standard table, you can always use the default database in the default session by referring to it through the databases array property of the _app object. For example,

_app.databases[ 1 ].copyTable( "Stuff", "CopyOfStuff" )