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.

MSSQL: Missing schema name causes syntax errors.

intruder's profile image intruder posted 4 years ago in HeidiSQL portable Permalink

When the schema name in database is different from 'dbo', HeidiSQL constructs object names in internal queries like this:

select ... from "DatabaseName".."TableName"

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

select ... from "DatabaseName".myschema."TableName"

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

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

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.