# 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.

Examples

         // 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()