CREATE

Opens the Table designer to create or modify a table interactively.

Syntax

The name of the table you want to create. Both CREATE ? and CREATE <filename skeleton> display a dialog box in which you can specify the name of a new table. The <filename> follows the standard Xbase DML table naming conventions.

If you don't specify a name, the table remains untitled until you save the file. If you specify an existing table name, dBASE Plus asks whether you want to overwrite it. If you reply no, nothing further happens.

[TYPE] FOXPRO | PARADOX | DBASE

Overrides the default table type set by SET DBTYPE. The TYPE keyword is included for readability only; it has no effect on the operation of the command.

PARADOX creates a Paradox table with a .DB extension.

FOXPRO creates a FoxPro table with a .DBF extension.

DBASE creates a DBF table with a .DBF extension.

CREATE MYTABLE PARADOX // Opens the table designer for "Mytable.db"

[WIZARD | EXPERT [PROMPT]]

If the PROMPT clause is used, a dialog appears asking if you want to use the Table designer or the Table wizard. You can then invoke either the designer or the wizard. The WIZARD clause without PROMPT causes the Table wizard to be invoked. You may use the keyword EXPERT instead of WIZARD.

CREATE MYTABLE PARADOX WIZARD // Opens the Table Wizard

CREATE MYTABLE PARADOX WIZARD PROMPT // Opens the New Table dialog

allowing a choice of using the Table Designer or the Table Wizard.

Description

CREATE opens the Table designer, an interactive environment in which you can create or modify the structure of a table, or the Table wizard, a tool that guides you through the process of creating tables. The type of table you create depends on the <filename> you specify, or the current database and the current setting of SET DBTYPE.

Create a table by defining the name, type, and size of each field. For more information on using the Table designer, see The Table designer window.

To modify an existing table, use the MODIFY STRUCTURE command.