I'm using the Schema Compare tool to compare two identical tables in two different schemas. However the Schema Compare tool detects a difference between the two tables in the check constraint section. In one table the check constraint is using the keyword written out as "Between" and in the other table the same constrain is written as "between". Because of the capitalization of the word, Toad detects the table as different.
WORKAROUND:
Manually change the capitalization of the keyword so the source and target objects are the same so the changes are not detected.
STATUS:
Enhancement Request ST92429 has been submitted to Development for consideration in a future release of Toad for DB2.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center