SQL and stored code development
The advanced SQL and stored code editor features make writing (SQL) code as easy as possible.
Database Workbench comes with tools to speed up your SQL and code writing.
Many of these features are customizable, from font to colors or to the functionality itself.
- Syntax highlighting for SQL and stored code
- SQL Insight with JOIN-completion
- Modern code editor
Syntax highlighting and more...
The modern code editor comes with all features you would expect:
- Syntax highlighting: keywords, strings, numbers, symbols, each has a configurable color
- Block staples: to highlight code structure, colored staples are drawn
- Parenthesis and block highlighting: whenever you hit a paired symbol, like "(", the corresponding paired symbol is highlighted
SQL Insight and Parameter Insight
The SQL Insight feature shows a context sensitive drop down list of object names. If you write FROM it will display a list of tables and views, if you're in the SELECT list, it will list the columns for the tables in the FROM clause. But there's more, when writing a JOIN clause, you can select the new table and it will show you ON-clause possibilities based on foreign keys in the database.
When calling system functions or stored procedure, Parameter Insight displays the parameter names and data types for these functions.
