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:

SELECT value FROM "SYS"."M_INIFILE_CONTENTS" WHERE KEY='log_mode'

To create a table:

create table table1(c varchar(20))

See also

life of a log segment