Creating a Free Table

A free table is a table that is not associated with a database. You might want to create a free table, for example, to store lookup information that many databases share.

To create a new free table

  1. In the Project Manager, choose Free Tables under Databases.

  2. Choose New, and then choose New Table.

  3. In the Create dialog box, enter a name for the table and choose Save.

  4. On the Fields tab of the Table Designer, type the name for the first field in the Name field.

  5. In the Type field, select a field type from the list.

  6. In the Width column, set the width of the column in characters.

  7. If Type is Numeric or Float, set the number of decimal places to display in the Decimal box.

  8. If you want to add an index to the field, select a sort order in the Index column.

  9. If you want the field to accept the input of null values, select NULL. You can choose to begin entering records immediately, or open the table later when ready to enter records.

    -or-

For example, the following code creates the free table smalltbl with one column, called name:

CLOSE DATABASES
CREATE TABLE smalltbl FREE (name c(50))

If no database is open at the time you create the table, you do not need to use the keyword FREE.

See Also

Table Creation | Creating a Database Table | Naming a Table | Working with Tables | Renaming a Table | Deleting a Database Table | Viewing Data in Tables | Customizing a Browse Window | Customizing Tables