How can I specify column order ?

shteveshteve Posts: 2
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 ?


  • Options
    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.

    Richard Mitchell
    Project Manager
    Red Gate Software Ltd
Sign In or Register to comment.