Skip to Content
avatar image
Former Member

How to list Hana tenant databases in a query?

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 19, 2017 at 02:42 PM

    You can determine the information from system view M_DATABASES.

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 01, 2017 at 07:21 AM

    Use this query,

    select * from "SYS"."M_DATABASES"

    Add comment
    10|10000 characters needed characters exceeded