SAP HANA: Cheat Sheet

1.       SQ L Syntax

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

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

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

b.      To display all schemas in the database:

                                                  i.      select * from schemas

c.       To display all tables:

                                                  i.      select * from tables

d.      To display all users:

                                                  i.      select * from sys.users

e.      To find out your log mode:

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

f.        To create a table:

                                                  i.      create table table1(cvarchar(20))