Multiple choice

Which command is the fastest among the following?

  1. COPY TO < New File >

  2. COPY FILE < File 1 > < File 2 >

  3. COPY STRUCTRUE TO <new file >

  4. COPY TO M FILE - DAT DELIMITED

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

COPY STRUCTURE TO copies only the table structure (field definitions) without any data records, making it fastest as no data transfer occurs. COPY TO copies all records with data. COPY FILE copies entire files including data. The structural copy operation is inherently faster than any data copy operation.