HDBSQL is an important component in SAP HANA which is available as a command line tool. Using various types of HDBSQL commands we can run various operations against the HANA databases like.
- Running SQL statements
- Database Procedures
- Queries for getting Database information
You can start the tool using the command hdbsql. Using \? command you will get the complete list of available commands in HDBSQL. Or you can use \h command for the same purpose. \c and \di commands are using for connecting and disconnecting the user from database respectively. \i command is using for importing the commands stored in an external batch file. After all the operation you can quit the tool by simply using \q command.