English

Error: Unable to rename table

Error Message

Renaming a table in a geodatabase stored in a DB2 database management system (DBMS) using 'sdetable -o rename' or in ArcCatalog returns the following error:

"Error: Unable to rename table <old_table_name> to <new_table_name>.
[IBM][CLI Driver][DB2/NT] SQL0750N The source table cannot be renamed because it is referenced in a view, materialized query table, trigger, SQL function, SQL method, check constraint, or referential constraint."

Cause

A table cannot be renamed in DB2 if there is a referential constraint of any kind, such as a trigger, on the table. All spatially enabled tables have triggers.

Solution or Workaround

In the case of feature classes, there is no solution. DB2 does not support renaming a table that contains any referential constraint, and feature classes have system-defined triggers.

If the table to be renamed includes a user-defined trigger, or other referential constraint, that can be removed, do the following:

1. Verify that the referential constraint is user-defined and can safely be removed.

2. Remove the referential constraint.

3. Rename the table.

4. Re-create the constraint.

Note:
Be aware that renaming a table invalidates any packages that are dependent on the renamed table.

Related Information