We have implemented cross-database autocomplete supporting several database platforms. Autocomplete has three capabilities:
- Display any words on the editor screen from above where your current cursor is
- Display SQL Syntax like SELECT, WHERE, FROM all the way to database platform-specific functions like CASE, DATEDIFF or CURRENT_DATE()
- Display the database, schema, table, column as you are typing
To initiate just the database browser which shows database objects plus snippets hit the Ctrl+Space button otherwise as you type if auto-complete is supported it will automatically popup.
We have pre-wired some special snippets within the editor as well to make writing SQL simpler. The table below details those snippets that are currently available.
|selall||will generate generic SELECT FROM|
|selwh||will generate generic SELECT FROM WHERE|
|upd||will generate an UPDATE statement|
|ins||will generate an INSERT statement|
|del||will generate a DELETE statement|
|expf||will generate a generic export to file statement|