Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

CREATE FROM Command

Visual Studio .NET 2003

Creates a table from a COPY STRUCTURE EXTENDED file.

CREATE [FileName1 [DATABASE DatabaseName [NAME LongTableName]]]
   FROM [FileName2]

Parameters

FileName1
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.
FileName2
Specifies the table (created either with COPY STRUCTURE EXTENDED or manually) from which the new table is created.

Remarks

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.

Example

The following example displays the structure of the orders table, copies the structure extended to the temp table, browses temp, creates a table called backup from temp, and displays the structure of backup.

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

See Also

COPY STRUCTURE EXTENDED | COPY STRUCTURE | CREATE

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.