When performing the operation of copying a table, a destination table which is a copy of the source table is created in the destination GDB.
The operation of moving a table consists of two stages: copying the source table to the destination GDB and removing the source table from the source GDB. Removing of the source table causes removing of queries built on the basis of this table. It is not difficult to understand that moving tables makes sense only between different GDB's.
Merging of tables differs from copying in the fact that the destination table already exists and it is supplemented with records of the source table. Moreover, values of fields of some destination table records can be replaced by values taken from source records. The structure of tables being merged (number of fields, their names, types and attributes) can differ, and the result retains the structure of destination. When merging tables having different structure, setting of fields is to be performed, this means setting correspondence between fields of source and fields of destination.
The main difference of copying a query from copying a table is the following. When copying a table, a table is created from a table, when copying a query, a table is created from a query. That is, not a new query is formed in the destination GDB, but a new table with the structure and contents which correspond to the query being copied.
Merging a source query and a destination table can be considered as successive performing of copying a query into a table and subsequent merging this table with the destination table.
Merging a source table or query and a destination query means adding source records to the base table of the destination query.
When copying a table, queries built on its base are not copied.
It is impossible to save settings in the settings file for the operations of copying and moving tables.
 |  |
