Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Alter Column

tobisch159's profile image tobisch159 posted 1 month ago in General Permalink

Hey,

unfortunately i get an error when i change a table field in HeidiSQL. It doesn`t care if its a rename of the field or a change of the data type.

I can do the change but if i cklick the save button the generated SQL always come to the error:

sql error 102 incorrect syntax near INT

it doesnt matter which data type here it is. The followin Code is generated bei HeidiSQL in "Alter Code": ALTER TABLE "dbo"."dispo_kopf" ALTER COLUMN "dk_ersteller" "dk_erstellerr" INT NULL DEFAULT NULL;

Maybe someone can help me?

Thanks a lot.

Best regards Tobias

tobisch159's profile image tobisch159 posted 1 month ago Permalink

Hey again,

i think i know whats going wrong.

i have a MSSQL database and HeidiSQL translates to MySQL Syntax.

Is there an option to set to MSSQL?

Best regards Tobias

ansgar's profile image ansgar posted 1 month ago Permalink

Yes, the modifications on table structure on servers other than MySQL or MariaDB is incomplete in HeidiSQL.

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.