Table differences

If the tables of the two compared MDQ files have the same name, but different values for column overrides or update key definitions, the table name will appear in red letters in the upper pane and both tables will appear in the bottom panes with the Column Overrides and/or Update Keys tab letters also in red letters. In the bottom panes, the unique value(s) will appear in red letters. If the table names of either of the two compared MDQ files are different, the name of each table appears in blue letters in the Database Differences window. If the tables are exactly the same, the name of the table in the upper pane and the Column Overrides and Update Keys tabs and related information would all appear in black letters.

Click the Column Overrides and Update Keys tabs in each pane to view the differences.

The columns on the Column Overrides tab (Column Name, Column Length, Presentation, and Interpret As) correspond to fields and list names in the Column Datatype Specification dialog.