Syntax error Checking schema creation in SAP HANA database

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

Updated on: 2020-03-13T07:54:21+05:30

2K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements