-750 THE SOURCE TABLE source-name CANNOT BE RENAMED OR ALTERED AS SPECIFIED

Explanation

An attempt was made to rename a table, index, or column, but the source object could not be renamed.

source-name

The name of the source table, index, or column.

Possible reasons for this error include, but are not limited to:

RENAME TABLE statements

• The table is referenced as the triggering table in one or more existing triggers.
• The table is a system-period temporal table or history table.
• The table is defined as an active resource limit table.
• The table is a clone table.
• The table has a clone table defined for it.
• The table is referenced in one or more view definitions.
• The table has a synonym defined for it.
• The table is an archive-enabled table.
• The table is an archive table.
• The table is an accelerator-only table.
• The table is defined as a Db2ZAI table.

RENAME INDEX statements

• The table is defined as an active resource limit table.
• The table is defined as a Db2ZAI table.

ALTER TABLE statements with RENAME COLUMN clause

• The table is a materialized query table.
• The definition of one or more materialized query tables references the table.
• The table is a system period temporal table or history table.
• The table is referenced as the triggering table in one or more existing triggers.
• The column is referenced in one or more view definitions.
• The column is referenced in a check constraint.
• The column has a field procedure defined.
• The table has a valid procedure or an edit procedure that is defined with row attribute sensitivity.
• An index is defined on the table with an expression that references the column.
• The table is an archive-enabled table.
• The table is an archive table.
• The table is defined as a Db2ZAI table.