How can I set MSSQL as the default language used by HeidiSQL when using the GUI to perform queries?

NameToRemember's profile image NameToRemember posted 2 years ago in General Permalink

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?

ansgar's profile image ansgar posted 2 years ago Permalink

You cannot modify these internal queries as a user. These are incompatibilities to MSSQL, where I am to blame. I have to separate these into compatible queries for MySQL, MSSQL, PostgreSQL etc.

In the meantime, you have to write such ALTER queries yourself in a query tab.

Please login to leave a reply, or register at first.