Show TOC

-7057: View definition contradicts new table definitionLocate this document in the navigation structure

Use

Explanation

  1. An attempt was made to add a column to a table or to drop a column from a table. SELECT * was used when defining the specified view table and new names were assigned to the view table columns. After the table was modified, the number of view table columns no longer matched the number of table columns.

  2. An attempt was made to drop a referential CONSTRAINT definition that is prerequisite for an updatable join view table.

User Response

  1. Delete the view table and define it again. Specify the required columns individually in the selected columns of the query definition.

  2. You can only delete the referential CONSTRAINT definition after you have deleted the updatable view table.