Introduction

---

Renaming tables is accomplished through the RenameTable method of the TDBISAMTable component. The properties used by the RenameTable method include the DatabaseName, TableName, and Exists properties.

Renaming a Table

---

To rename a table, you must specify the DatabaseName and TableName properties of the TDBISAMTable component and then call the RenameTable method. The table component must be closed and the Active property must be False. It is usually good practice to also examine the Exists property of the TDBISAMTable component first to make sure that you don't attempt to rename a non-existent table. If you do attempt to rename a non-existent table an EDBISAMEngineError exception will be raised. The error code given when a table rename fails due to the table not existing is 11010 and is defined as DBISAM_OSENOENT in the dbisamcn unit (Delphi) or dbisamcn header file (C++).

The following example shows how to rename the "customer" table to the "oldcustomer" table using the RenameTable method:

begin
   with MyDBISAMTable do
      begin
      DatabaseName:='d:\temp';
      TableName:='customer';
      if Exists then
         RenameTable('oldcustomer');
      end;
end;

In addition to using the TDBISAMTable RenameTable method for renaming tables, DBISAM also allows the use of the RENAME TABLE SQL statement.