New feature: warning on reserved words

Mary Bonney's profile image Mary Bonney posted 9 years ago in Feature discussion Permalink
I recently used the word "desc" (short for "description") as a new column name. Then I had problems and realised that "desc" is a reserved word. Just thought then that it might be a useful feature for HeidiSQL to indicate when a table or column was given a reserved word as a name. It could, for example, appear in red or a dialog could pop-up (more annoying).

There are so many reserved words, many of which are likely to get picked for names (date, order, etc), that it would be very convenient.
ansgar's profile image ansgar posted 9 years ago Permalink
I know that there are users wanting to use such keywords as column or table names, and then there are users like you (and me) wanting to get warned about that. In theory, there is no problem at all when such identifiers are quoted correctly. And HeidiSQL does quote most column and tables names.

If I had a complete list of keywords, that would be not a big deal. But note that would require different keyword lists for MySQL, MSSQL and PostgreSQL.

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