ERROR

Unable to rename table

Last Published: April 25, 2020

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.

Article ID:000003093

Software:
  • Legacy Products
  • ArcMap

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options