COPY STRUCTURE

Create a new database based on current database structure

Syntax

COPY STRUCTURE TO <xcFileName> [FIELDS <field,...>]

Arguments

TO <xcFileName> is the name of the new database file to create. (.dbf) is the default extension if none is given. It can be specified as a literal file name or as a character expression enclosed in parentheses.

FIELDS <field,...> is an optional list of field names to copy from the currently open database in the specified order, the default is all fields. Names could be specified as uppercase or lowercase.

Description

COPY STRUCTURE create a new empty database file with a structure that is based on the currently open database in this work-area.

COPY STRUCTURE can be use to create a sub-set of the currently open database, based on a given field list.

COPY STRUCTURE command is preprocessed into __dbCopyStruct() function during compile time.

     // Create a new file that contains the same structure
      USE TEST
      COPY STRUCTURE TO MyCopy

      // Create a new file that contains part of the original structure
      USE TEST
      COPY STRUCTURE TO SomePart FIELDS name, address

Status

Ready

Compliance

COPY STRUCTURE works exactly as in CA-Clipper

Platforms

All

See Also

• COPY STRUCTURE EXTENDED
• DBCREATE()
• DBSTRUCT()
• __dbCopyStruct()
• __dbCopyXStruct()
• __dbCreate()
• __dbStructFilter()