MSSQL multiple schema names bug

intruder posted 1 year ago in General

When the schema name in database is different from 'dbo', or database has more than one schema names - HeidiSQL constructs object names in internal queries like this:

select *** from "DatabaseName".."TableName" (note double period between databse name and table name)

When I manually run same query with a fix - it works fine:

select *** from "DatabaseName".myschemaname."TableName"

And when database schema name is default (dbo) and the only - Heidi handles it correctly:

select *** from "DatabaseName".dbo."TableName"

Please fix it.

simone posted 8 months ago

Bump. I'm having the same issue, it would be nice to have a fix

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