Checking schema creation in SAP HANA database



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";
  • Schema_Name
  • Schema_Owner
  • HAS_PRIVILEGES
  • Create_Time


Advertisements