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