As I’m comparing two versions of a table from one schema to another using the Single Object Compare, Toad only recognizes that some of the columns are “new” in one of the tables, treating others as a column name change. This seems to occur when columns are named similarly, as in having a common prefix. Here’s an example:
CREATE TABLE tester1 (runabc NUMBER, rundef NUMBER, runghi NUMBER, runjkl NUMBER);
CREATE TABLE tester2 (runabc NUMBER, rundef NUMBER, runjkl NUMBER, runghi NUMBER, runxyz NUMBER);
Comparing the two shows in the Compare Scripts that “runjkl” and “runxyz” are differently named instead of different columns. I’d think that one would want to compare the column names as a whole, or at least have the option to do that.
I have a better real-world example that I could send offline, if needed.