ADD TABLE Command

Example   See Also

Adds a free table to the current database.

Syntax

ADD TABLE TableName | ?
  [NAME LongTableName]

Arguments

TableName

Specifies the name of the table added to the database.

?

Displays the Open dialog box from which you can choose a table to add to the database.

NAME LongTableName

Specifies a long name for the table. Long names can contain up to 128 characters and can be used in place of short file names that have a .DBF extension.

Remarks

After the table is added to the database, you can perform the same operations on it as you can on any other table.

Once the table is added to the database, it is no longer free. However, any table in the database can be made free by issuing REMOVE TABLE.

The table you are adding:

• Must be a valid .DBF file.
  
  
• Cannot have the same name as an existing table in the open database, unless you assign the table a unique long name.
  
  
• Cannot exist in another database. Use REMOVE TABLE to remove the table from another database.

The database to which you are adding a table cannot be involved in a transaction.