MSSQL: Missing schema name causes syntax errors.

3 posts
[expired user #10375]'s profile image [expired user #10375] posted 8 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.