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

raja
Published on 25-Apr-2018 20:00:42
Advertisements