Tuesday, 14 July 2020

How to check database version details with command

We will see how to get HANA DB version details with the help of command 


We need to follow the below steps.

1: Login in HANA Studio with select permission and run below command.  

2: Run below command to get details 

SELECT TOP 1 D.VERSION, H.VALUE FROM M_DATABASE D LEFT OUTER JOIN SYS.M_HOST_INFORMATION H ON H.KEY = 'build_branch'





Thanks

Rupesh Chavan