Checking schema creation in SAP HANA database

In SAP HANA database, I want to fetch list of schemas, owner name and creation_time of all schema. What is SQL query to get this information?

0 0

1 Answer

SAP ABAP Expert

Answered on 25th Apr, 2018

To check this detail, you should have access on “SYS” schema. Run the following SQL query and it will fetch the following columns:

SELECT * FROM "SYS"."SCHEMAS";

0 0