Article Number: 000146595
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))
10 Apr 2021
3
Solution