Comparison Fails Between Table Indexes
JYoder
Posts: 5
In comparing 2 DBs, one has this line in the table for an index...
CREATE NONCLUSTERED INDEX [idx_Name] ON [dbo].[TABLE1]([EmployeeKey]) INCLUDE([DeductionKey], [CheckKey])
and the other DB's table of the same name has this...
CREATE NONCLUSTERED INDEX [idx_Name] ON [dbo].[TABLE1]([EmployeeKey]) INCLUDE([CheckKey], [DeductionKey])
The only difference is the order of the fields at the end. How can it detect them as a difference and recreate the table?
CREATE NONCLUSTERED INDEX [idx_Name] ON [dbo].[TABLE1]([EmployeeKey]) INCLUDE([DeductionKey], [CheckKey])
and the other DB's table of the same name has this...
CREATE NONCLUSTERED INDEX [idx_Name] ON [dbo].[TABLE1]([EmployeeKey]) INCLUDE([CheckKey], [DeductionKey])
The only difference is the order of the fields at the end. How can it detect them as a difference and recreate the table?
Comments