copyTable( )
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" )