Background documentation-1115: Too many intern columns Locate this document in the navigation structure

 

Explanation

An ALTER TABLE statement or a CREATE VIEW statement generates a table description either containing more columns than allowed or whose rows exceed the maximum length. Under certain circumstances, this situation can occur because of columns that are invisible to the user.

User Response

For a CREATE VIEW statement, check whether some output columns can be omitted. For an ALTER TABLE statement, check whether the specified column width can be decreased. Check also whether previous ALTER TABLE statements generated so many invisible columns that MODIFY DEFINITION should be used to remove invisible columns instead of ALTER DEFINITION. However, this leads to the copying of the table, a procedure which requires considerable space and time.