CREATE FROM

Purpose

Create a table from the contents of another table

Syntax

CREATE <filename1> | (<expC1>) FROM <filename2> | (<expC2>)

See Also

COPY, COPY STRUCTURE, COPY STRUCTURE EXTENDED, CREATE, SET CLIPPER

Description

The CREATE FROM command creates a new table, determined by the contents of a table created with the COPY STRUCTURE EXTENDED command. The filenames can be substituted with a <expC1>, enclosed in round brackets, which returns a valid filename. The FROM table consists of five fields, these are:

Field	Type	Width	Description
FIELD_NAME	Character	32	Field name
FIELD_TYPE	Character	1	Data type of field
FIELD_LEN	Numeric	3	Width of field
FIELD_DEC	Numeric	3	Number of decimal places
FIELD_DES	Character	25	Field Description

Each record of the FROM table defines a field. The structure of the new table, <filename1>, will be created from these field definitions.

Example

use patrons
copy structure extended to patstru
close patrons
create newpatron from patstru

Products

Recital Server, Recital