SAP HANA Cheat Sheet

SAP HANA Cheat Sheet

SQL Syntax

To issue SQL commands on a HANA database use the command hdbsql:

hdbsql -i 42 -u myuser -p mypassword "select * from sys.users"

This will log in to HANA, instance 42 with user myuser and password mypassword and execute the SQL statement select * from sys.users.

To display all schemas in the database:

select * from schemas

To display all tables:

select * from tables

To display all users:

select * from sys.users

To find out your logmode:


To create a table:

create table table1(c varchar(20))

See also

life of a log segment

Article ID: SLN311051

Last Date Modified: 08/16/2018 03:22 AM

Rate this article

Easy to understand
Was this article helpful?
Yes No
Send us feedback
Comments cannot contain these special characters: <>()\
Sorry, our feedback system is currently down. Please try again later.

Thank you for your feedback.