DBeaver Documentation

DOWNLOAD

SQL Assist and Auto-Complete

The SQL Assist feature provides auto-completion of database object names and SQL commands, and other keywords in queries.

To perform some object name auto-complete, press Ctrl+Space or right-click the required place in the query and click SQL Assist on the context menu. DBeaver searches for objects in a database by their names and/or descriptions.

When you start typing an SQL keyword in a statement, DBeaver offers auto-complete options as well.
Another auto-complete function is that it searches for the last entered identifier - type the first letter and press Ctrl+Shift+Space.

You can also press Ctrl+Space after the asterisk in the query similar to SELECT * FROM tableName or similar to INSERT INTO tableName (*) (brackets are important) (you can use ()[]{} brackets) - the asterisk will be replaced with a list of all the table columns.

Hippie Engine

Hippie Engine provides autocompletion based on information of the current script file. It scans files looking for words and adds proposals based on similarity with the given string.

It can be turned off/on: Window -> Preferences -> Editors -> SQL Editor -> Activate Hippie Engine for autocompletion

Did we resolve your issue?