on 02-19-2017 2:38 PM
Hi everyone,
I have recently started to learn Hana database and I need a query to list all tenant databases when I am connected to the database server using SYSTEM user.
Thanks in advance.
You can determine the information from system view M_DATABASES.
Regards,
Florian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use this query,
select * from "SYS"."M_DATABASES"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
it depends on where you are executing that SQL:
================================================
open SQL-console in a tenantDB => there is no difference between SQL
select * from M_DATABASES
and SQL
select * from "SYS"."M_DATABASES"
both SQL gives back as result-list: 1 entry = the tenantDB
=================================================
open SQL-console in a systemDB => there is no difference between SQL
select * from M_DATABASES
and SQL
select * from "SYS"."M_DATABASES"
both SQL gives back as result-list: 2 entries = the tenantDB + the systemDB
=================================================
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.