Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

delete a schema with nms as namespace

Avatar

Avatar
Boost 250
MVP
DavidKangni
MVP

Likes

255 likes

Total Posts

372 posts

Correct Reply

151 solutions
Top badges earned
Boost 250
Validate 1
Give Back 5
Give Back 3
Give Back 25
View profile

Avatar
Boost 250
MVP
DavidKangni
MVP

Likes

255 likes

Total Posts

372 posts

Correct Reply

151 solutions
Top badges earned
Boost 250
Validate 1
Give Back 5
Give Back 3
Give Back 25
View profile
DavidKangni
MVP

27-07-2020

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.

DavidKangni_0-1595880828293.png

 

Any thoughts @wodnicki  @kapilKochar  @Milan_Vucetic  @Raj_bounteous  @Jyoti_Y  @_Manoj_Kumar ?

 

Thanks,

David

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

960 likes

Total Posts

1,090 posts

Correct Reply

509 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

960 likes

Total Posts

1,090 posts

Correct Reply

509 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

28-07-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

Answers (0)