Automatic upper/lower-casing of database object names in MS SQL

[expired user #10708]'s profile image [expired user #10708] posted 7 years ago in Feature discussion Permalink

I'm trying to use Heidi with MS SQL. It really is annoying how MS SQL Server is case sensitive with regards to table and field names. I cannot change collation of the database at a whole, and table names in the software I work with are UPPERCASED, all fieldnames too. This is sooo annoying, I keep getting errors, I keep fixing the queries over and over again.

So here's a thought: text parser of a query editor knows which bit of the query text is a table or field name, or generally a database object name. It knows because it applies syntax coloring or intellisense lookups. So why not have an option (per-database setting) to change case of database object names on the fly -- either while typing or before execution. The result of such case change should be visible in editor.

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