How to: Create Free Tables

JavaScript Editor js editor     Web development 



Main Page

You can create free tables using a wizard or as an empty table. A wizard helps you create a table using your answers to a series of questions.

When you create a table, a table (.dbf) file is created to store the table file. For information about naming tables, see How to: Name Tables.

To create a free table using a wizard

  1. On the File menu, click New.

  2. In the New dialog box, click Table, then Wizard.

  3. Follow the instructions on the wizard screens.

For more information, see Table Wizard.

You can also begin the wizard from a project in the Project Manager by expanding the Data node, click the Free Tables node, and then New. In the New Table dialog box, click Table Wizard. For more information, see Project Manager Window.

To create an empty free table

  1. On the File menu, click New.

  2. In the New dialog box, click Table, and then New file.

  3. In the Create dialog box, select the location you want to save the database table, and type a name for the table.

  4. Click Save.

    The Table Designer opens so you can specify table fields, items, and other attributes.

For more information, see Table Designer (Visual FoxPro).

To create a free table in a project

  1. Open the project in the Project Manager.

  2. In the Project Manager, expand the Data node.

  3. Click the Free Tables node, and then New.

  4. In the New Table dialog box, click New Table.

  5. In the Create dialog box, select the location you want to save the database table, and type a name for the table.

  6. Click Save.

    The Table Designer opens so you can specify table fields, items, and other attributes.

For more information, see Project Manager Window and Table Designer (Visual FoxPro).

To create a free table programmatically

  • Perform one of the following:

    • To create a table by opening the Table Designer, close any open databases and use the CREATE command.

    -OR-

    • To create a table without opening the Table Designer, use the SQL CREATE TABLE command. If a database is open, include the FREE keyword.

For more information, see CREATE Command and CREATE TABLE - SQL Command.

See Also



JavaScript Editor js editor     Web development