Options

How can I specify column order ?

shteveshteve Posts: 2
edited November 16, 2007 1:58AM in SQL Data Compare Previous Versions
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 ?
· Share on Twitter

Comments

  • Options
    richardjmrichardjm Posts: 598
    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
    Richard Mitchell
    Project Manager
    Red Gate Software Ltd
    · Share on Twitter
Sign In or Register to comment.