Multi column index SQL preview is often incorrect, with missing columns or incorrect order of columns.
Aubrey Jones 8 years ago • updated by Michał Kołodziejski 8 years ago • 1
Create a table with multiple columns. Create a multi column index that doesn't include the PK. Press the SQL Preview button... maybe it's right, maybe it isn't. Reorder the columns in your index, or add/delete one, and try again. I bet it's not correct now.
Customer support service by UserEcho
However, I agree that there should be automatic save operation before generating SQL Preview, we'll add this soon.