Share via

Renaming a Table

  • Article

You can rename database tables through the interface because you are changing the long name. If you remove the table from the database, the file name for the table retains the original name. Free tables do not have a long name and can only be renamed using the language.

To rename a table in a database

  1. In the Database Designer, select the table to rename.
  2. From the Database menu, choose Modify.
  3. In the Table Designer, type a new name for the table in the Table Name box on the Table tab.

To rename a free table

  • Use the RENAME command.

    Caution   If you use the RENAME command on tables associated with a database, the command does not update the backlink to the database and can cause table access errors.

See Also

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