Which of the following command executes faster?

Options
- Copy to < New file>
- Copy File < FILE 1>< FILE2>
- Copy Structure to < NEW FILE>
- Copy to M FILE-DAT DELIMITED.

CORRECT ANSWER : Copy Structure to < NEW FILE>

Discussion Board
Copy Structure to < NEW FILE>

Copy Structure to < NEW FILE> 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: It specifies the name of the table as it appears in the database.

Prajakta Pandit 03-14-2017 08:08 AM

Write your comments


Enter the code shown above:

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


Related Content

Advertisement
 
▲