À l'étude

Multi column index SQL preview is often incorrect, with missing columns or incorrect order of columns.

il y a 9 ans • mis à jour par il y a 9 ans • 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.

Voter

Réponses 1
Plus ancien en premier
- Plus récent en premier
- Plus ancien en premier

À l'étude

il y a 9 ans

I'm quite sure this is caused with lack of "save" operation before generating SQL Preview. Please try to "ctrl+s" (or click save button) before generating SQL Preview. Does this help?

However, I agree that there should be automatic save operation before generating SQL Preview, we'll add this soon.

Répondre
- Signaler comme
- Inapproprié
- Pourriel
- Doublon
|

Service d'assistance aux clients par UserEcho