Hello how are you? I really like this HeidiSQL program, but I have noticed that I cannot create indexes on MS Sql Server 2014 tables. When I create one following the correct procedure, I get an error " SQL error (1750): Failed to create the constraint or index. See the previous errors. "Attached screenshots.
And I see in the command history, it tries to do an ALTER TABLE instead of a CREATE NONCLUSTERED INDEX
Is it a mistake on my part? Or is there something that can be done to fix it?
Thank you very much.