CREATE FROM Command
Creates a table from a COPY STRUCTURE EXTENDED file.
CREATE [FileName1 [DATABASE DatabaseName [NAME LongTableName]]] FROM [FileName2]
- Specifies the name of the new table to create.
- DATABASE DatabaseName
- Specifies a database to which the new table is added.
- NAME LongTableName
- Specifies a long name for the new table. Long names can contain up to 128 characters and can be used in place of short file names in the database.
- Specifies the table (created either with COPY STRUCTURE EXTENDED or manually) from which the new table is created.
This variation of CREATE assumes that the table specified in FileName2 has been created either with COPY STRUCTURE EXTENDED or manually. A new table FileName1 is created with the structure described in FileName2. The newly created table becomes the active table.
If you don't include either FileName1 or FileName2 or both, a dialog box is displayed. In this dialog, you can specify the file to be created, or the FROM file, or both.
Note that all records in FileName2, including those marked for deletion, are used to created FileName1.
The following example displays the structure of the
orders table, copies the structure extended to the
temp table, browses
temp, creates a table called
temp, and displays the structure of
CLOSE DATABASES CLEAR SET PATH TO (HOME(2) + 'Data\') && Sets path to database USE orders DISPLAY STRUCTURE WAIT WINDOW 'Structure of the orders table' NOWAIT COPY STRUCTURE EXTENDED TO temp USE temp WAIT WINDOW 'Temp table has 1 row per field in ORDERS' NOWAIT BROWSE CREATE backup FROM temp USE backup DISPLAY STRUCTURE WAIT WINDOW 'Backup.dbf has the same structure as ORDERS' NOWAIT USE DELETE FILE temp.dbf DELETE FILE backup.dbf