delete a schema with nms as namespace | Community
Skip to main content
DavidKangni
Community Advisor
Community Advisor
July 27, 2020
Solved

delete a schema with nms as namespace

  • July 27, 2020
  • 1 reply
  • 1636 views

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-1  @jyoti_yadav  @_manoj_kumar_ ?

 

Thanks,

David

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jonathon_wodnicki

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

1 reply

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
July 28, 2020

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
Community Advisor
Community Advisor
July 28, 2020

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

David Kangni