How to delete PACKAGE from HANA studio

How to delete PACKAGE from HANA studio

1.Unable to delete package from HANA studio

2. While deleting from HANA studio it will showing inactive object present in package and refusing to delete the package.

     You can find out inactive object using below sql queries

 

SELECT * FROM _SYS_REPO.INACTIVE_OBJECT WHERE PACKAGE_ID='test'

 

3. Once you have found the inactive object using above query

    You can delete it using below query

 

Delete FROM _SYS_REPO.INACTIVE_OBJECT WHERE PACKAGE_ID='test'

 

4. Once you have deleted inactive object you can delete the package from HANA studio.