Earlier this year the first version of the SAP HANA Database Explorer Visual Studio Code extension was released to the Visual Studio Code marketplace.

You can find the features introduced in previous versions in my other blog posts.

• What’s New in the SAP HANA Database Explorer Visual Studio Code Extension Version 1.5
• What’s New in the SAP HANA Database Explorer Visual Studio Code Extension

What’s New?

This week, version 1.6 of the extension has been released to the Visual Studio Code marketplace. In addition to some bug fixing and general improvements, the new version brings several noteworthy features.

Parameterized Statements

The SQL console can execute statements with parameters. When a statement with parameters is encountered, a new tab is shown that allows the user to enter the parameter values and then execute the parameterized statement.

Connection Auto-commit Setting

The current connection’s auto-commit state can be set from the SQL console via an icon in the menu bar.

CREATE Statement Generation

A CREATE statement can be generated for database objects via the context menu of the database objects in the catalog browser. By default the CREATE statement will be opened in a new SQL console. As an additional option the CREATE statement can also be copied to the clipboard.

Copy Object Names

The name and full name (schema + object name) of database objects can be copied to the clipboard via the context menu of the database objects in the catalog browser.

SQL Console Font Size

The SQL console font size can now be changed via the Visual Studio Code setting “Editor: Font Size”.

Stay tuned for more exciting new features in future releases!