Copy Structure command executes faster - Database

Q.  Which of the following command executes faster?
- Published on 27 Aug 15

a. Copy File < FILE 1>< FILE 2 >
b. Copy Structure to < NEW FILE >
c. Copy to M FILE - DAT DELIMITED.
d. Copy to < New file >

ANSWER: Copy Structure to < NEW FILE >
 

    Discussion

  • Nirja Shah   -Posted on 02 Nov 15
    - This command creates a new, empty table with the same structure as the currently selected table.

    - Syntax
    COPY STRUCTURE TO TableName [FIELDS FieldList]
    [[WITH] CDX | [WITH] PRODUCTION]
    [DATABASE cDatabaseName [NAME cTableName]]

    Parameters are as follows

    1. TableName
    It specifies the name of the new, empty table to create.

    2. FIELDS FieldList
    It specifies that only the fields whose names are specified in the FieldList are copied to the new table. If you omit FIELDS FieldList, all fields are copied to the new table.

    3. [WITH] CDX | [WITH] PRODUCTION
    It creates a structural index file for the new table that is identical to the structural index file of the existing table. The tags and index expressions from the original structural index file are copied to the new structural index file.
    The CDX and PRODUCTION clauses are identical.

    4. DATABASE cDatabaseName
    It specifies the name of an existing database to which the new table is added. Note that the table and field properties are not copied to the database.

    5. NAME cTableName
    Specifies the name of the table as it appears in the database.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)