How can I specify column order ?

shteve

I am comparing several similar views - I do not understand how the column order in the 'Object Differences' is determined - I'm sure it's nit picky, but is there a trick to setting the column order ?

richardjm

We compare the columns in the order they are specified in the views themselves, or the tables if you're using something like (select * from...). You can't specify this order manually unless you use the SQL Toolkit API to perform the comparison.

Generally this order is the case, the difficulty comes when tables aren't the same in the two databases in this case I think we try to use the columns from database 1 in order matching them up to columns in database 2 although I'll not swear to that.

HTH