Skip to Content
Former Member
May 11, 2016 at 08:44 PM

Delete schema owned by _SYS_REPO


Hi all,

I have created a schema using .hdbschema in the editor which I now want to remove. As noted in the documentation, deleting the .hdbschema doesn't remove the schema like removing .hdbtable files do, however unfortunately the documentation didn't say what to do in this case. When I try to drop the schema in the Catalog it tells me I don't have sufficient authorizations to do this. Could someone please tell me what the procedure is to remove schemas created this way?