Background documentation-1026: Too many differences between old and new view definition Locate this document in the navigation structure

 

Explanation

A CREATE VIEW statement was specified with the REPLACE option. A view table with the specified name already exists. The existing view definition differs so much from the specified view definition that the definitions depending on this view table can no longer be maintained in a consistent state. The CREATE VIEW statement therefore fails.

User Response

Do not modify the specified view table or check which of the depending definitions, e.g. view tables, privileges, and so on; do not match the new view definition. If there are some, delete them before re-executing the CREATE VIEW statement, and recreate them afterwards in an appropriate format.