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:
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
- Legacy Products
- ArcMap
Receive notifications and find solutions for new or common issues
Get summarized answers and video solutions from our new AI chatbot.
Related Information
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App