admin管理员组

文章数量:1287626

After a recent update to 24.3.5 community edition, the auto completed for column names is now including the table name when it inserts the column name. I can not figure out how to disable this in the preferences.

Previously it would just insert the column name as expected, now it inserts the full string 'tl_2022_school_districts_elementary.statefp'

Anyone know how to disable this and just have it insert the column name?

After a recent update to 24.3.5 community edition, the auto completed for column names is now including the table name when it inserts the column name. I can not figure out how to disable this in the preferences.

Previously it would just insert the column name as expected, now it inserts the full string 'tl_2022_school_districts_elementary.statefp'

Anyone know how to disable this and just have it insert the column name?

Share Improve this question asked Feb 23 at 8:24 Blake GirardotBlake Girardot 737 bronze badges 2
  • try to add alies to your table name, like: FROM tablename a and then you'll see a.columnname – Lev Gelman Commented Feb 23 at 8:35
  • Just noting version 24.2.5 is the last version that did not have this behavior – Blake Girardot Commented Feb 25 at 12:34
Add a comment  | 

1 Answer 1

Reset to default 1

Got the same issue.

Did you try to tweak the preferences?

Preferences → Editors → SQL Editor → Code Completion → "Insert table name (or alias) with column names" = Disabled (N/A)

As per my own feedback, I didn't see any change after disabling it. It looks like the v.24.3.5 has a different behaviour.

本文标签: dBeaverhow to disable table names in column name insertsStack Overflow