Error: Unable to rename table
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."
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.
Be aware that renaming a table invalidates any packages that are dependent on the renamed table.