As we know that HANA
MDC feature introduced in HANA version 1.0 SPS 09 and Starting from HANA 2.0 SPS01, Multitenant Database Containers (MDC) became the standard. Please refer below snap
When we are working HANA DB version 1.0 SPS 09 to 1.0 SPS 12, if some once ask the question that HANA DB which we are using is it MDC or Single DB?
We can check the same by running the simple command as shown below.
select * from "PUBLIC"."M_DATABASES"
if the database is single DB then you will get below details
If the database is installed at MDC then you will get below details
Note:
We
can see in an above snap how we can find single DB and MDC
Sometimes it's possible
that you may not receive any output from the above select query. That time you can
find details by running below given SQL statements
1: HANA_Configuration_Parameters -- SQL Query
MDCSYS -- it means statement executed at SYSTEM database
MDCTEN -- It means statement executed at Tenant database
2: HANA_Configuration_Overview --- SQL Query
We can see that its MDC ( tenant DB / multitenant system) with help both 1 and 2 queries.
Note: select query as per HANA DB version and you can down SQL statement from below link
Note 1969700 - SQL statement collection for SAP HANA