delete a schema with nms as namespace

[DavidKangni]

Hi all,

Do you know how I can delete a schema created with nms as namespace? 

Quick summary, one of my developer created a schema and used nms as namespace. so it's automatically considered it as an ootb schema and I'm not able to delete it both with my operator (with administration named right) and admin operator. 

Also tried to delete it from the back end using SQL as ACC is installed on premise but not able as database structure update was not completed.

I'm thinking to use internal user in next step but not sure if it will work.

Any thoughts @Jonathon_wodnicki  @kapilKochar  @Milan_Vucetic  @Raj_Ganta  @Jyoti_Yadav  @_Manoj_Kumar_ ?

Thanks,

David

[Jonathon_wodnicki · Accepted solution]

Hi,

That must be a new thing. Internal has same access as anyone in operator table with admin right.

Since you have admin right, just use a sql script?

delete from xtkentity where sname='Marketing offers';
drop table ...

Thanks,

-Jon

[DavidKangni]

Hi Jon,

It works. They added this restriction in the latest release. drop table was not working as the database structure was not updated.

Thank you so much.

David