THE SOURCE TABLE source-name CANNOT BE RENAMED BECAUSE IT IS REFERENCED IN EXISTING VIEW DEFINITIONS OR TRIGGER DEFINITIONS

Conclusão: The source table in a RENAME statement cannot be renamed because it is referenced in one or more existing view definitions or it is referenced as the triggering table in one or more existing triggers. The table has check constraints defined.

Ação do sistema: The statement cannot be executed.

Resposta ao Desenvolvedor: Change the source name to the name of an object that can be renamed and reissue the statement. Drop any triggers defined on the table before issuing the RENAME statement. These can be found by querying the system catalog: SELECT * FROM SYSIBM.SYSTRIGGERS WHERE TBNAME = 'source-name'

SQLSTATE: 42986