Go to Job log → Current and you can see last job ran for changing authoring schema. You can double click on job type to open the details. In job details, you can see status of job details.

In SAP HANA system, you have one view available in SAP System schema named called as “OBJECT_DEPENDENCIES”

In SAP HANA system, you have one view available in SAP System schema named called as “OBJECT_DEPENDENCIES” and it can be used to get the information of SAP Tables.To see details in this view, run this query: select * from "SYS"."OBJECT_DEPENDENCIES";This will display all the details of SAP HANA system.Read More

This can be checked using below SQL query and it will display all the available schema in HANA system.select distinct BASE_SCHEMA_NAME from "SYS"."OBJECT_DEPENDENCIES"

This can be checked using below SQL query and it will display all system schema in HANA system.select distinct BASE_SCHEMA_NAME from "SYS"."OBJECT_DEPENDENCIES" where BASE_SCHEMA_NAME like ‘_SYS%’;

You can check this detail using a SQL query in HANA. You have to pass schema name in Where condition. Try running below SQL query and this will show you list of all tables in a schema.Select distinct BASE_OBJECT_NAME from "SYS"."OBJECT_DEPENDENCIES" where BASE_SCHEMA_NAME like 'AF_HANA';AH_HANA- Schema nameRead More

This can be checked via SQL query on view in HANA system. Try run the below query −SELECT "DEPENDENT_OBJECT_NAME" from "SYS"."OBJECT_DEPENDENCIES" WHERE "BASE_SCHEMA_NAME"  = 'AF_HANA' AND "BASE_OBJECT_NAME" = 'STORE' AND "DEPENDENT_OBJECT_NAME" Not like '%hier%';

You can check this detail using a SQL query in HANA. You have to pass schema name in Where condition. Try running below SQL query −SELECT "DEPENDENT_OBJECT_NAME" from "SYS"."OBJECT_DEPENDENCIES" WHERE "BASE_SCHEMA_NAME"  = 'AF_HANA' AND "BASE_OBJECT_NAME" = 'STORE' AND "DEPENDENT_OBJECT_NAME" like '%hier%';Read More

With use of Where-used functionality you can easily find this information. Right click on object name → Where-Used

In SAP HANA, you can delete all inactive objects in workspace. In HANA Modeler Perspective → Delete Inactive Objects..You can also revert to last active version if exists.