For example when I try to use the GUI to alter an ID column to use AUTO_INCREMENT it doesn't work because SQL doesn't have AUTO_INCREMENT, it use this syntax instead... `Personid int IDENTITY(1,1) PRIMARY KEY
what i'd like to be able to do is make changes/queries using the GUI of heidiSQL with my SQL database NOT MYSQL database.
Is that possible? Or is HeidiSQL's GUI only designed for use with mysql and I'll have to write my own queries everytime I want to make a change?