In this article

ICE06

In this article

ICE06 checks every table to validate that all the columns listed in the _Validation table are present in the table. If a table does not exist, any _Validation entries for that table are ignored.

The purpose of ICE06 is to detect instances in which an author tries to use a new _Validation table that reflects a schema change with an old database that has not been updated. ICE06 also detects the reverse case of an old _Validation table being used with an altered database.

Note that the internal validation performed by ICE03 catches the instance of a table column not defined in the _Validation table being listed in the columns catalog. The use of both ICE03 and ICE06 therefore ensures every column in the database is tested.

Result

ICE06 posts an error when there is a table column defined in the _Validation table that is not listed in the _Columns table.

Related topics

The feedback system for this content will be changing soon. Old comments will not be carried over. If content within a comment thread is important to you, please save a copy. For more information on the upcoming change, we invite you to read our blog post.