In this blog post, let’s learn about the error message “20416 Table model-table-name is referenced by ref-obj-type ref-obj-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20416 Table model-table-name is referenced by ref-obj-type ref-obj-name.
Reason for the Error
The model table for MODIFY REPARTITION is referenced by a view, a trigger, or a foreign key constraint. This includes the case where the model table is the subject table of a trigger.
Solution
Specify a model object with no offending referencing object