Search code examples
sqlselectdbeaver

Turn select * into individual field names in DBeaver

I stumbled upon one of the most amazing features in DBeaver, where I had:

select *
from foo

And I hit some key combination that turned * into an individual list of field names:

select field1, field2, field3, field4
from foo

The problem is I cannot repeat it, no matter what I try, and I can't find any documentation on the feature.

If anyone knows the key combination to make this work, please let me know.

Solution

  • Lukasz is right.
    After you type the asterisk *, hit Ctrl+Space and the intellisense window (SQL Assist) will appear with the field names from the table.