question delete column on custom table? in Developer forum

delete column on custom table?

patk1000 — Tue, 01 Mar 2016 23:30:39 GMT

I discovered a "feature" of ServiceNow where I am unable to delete a column ON A CUSTOM TABLE that is not prefixed with 'u_'. For example, there is no button to delete a table named 'user_global_snat'.

I need to delete it rather than simply marking as inactive and ignoring it.

I tried mucking with the live JS in developer console to enable the 'X' button, but the delete operation didn't actually work.

Re: delete column on custom table?

Pradeep Sharma — Wed, 02 Mar 2016 00:47:54 GMT

Hi Pat,

You mean "user_global_snat'" is a OOTB field?

Re: delete column on custom table?

patk1000 — Wed, 02 Mar 2016 01:37:11 GMT

It is not. The "user_global_snat" column was created by myself on a table I created. Thats where a bit of the frustration is.

Re: delete column on custom table?

Pradeep Sharma — Wed, 02 Mar 2016 01:42:00 GMT

There should be "Delete column" button on the header if you go to the dictionary of the field.

Please make sure you are in the right scope. "Delete column" button will not be visible if you are trying to delete it from other scope.

Re: delete column on custom table?

patk1000 — Thu, 03 Mar 2016 17:59:28 GMT

No luck. No option to delete in drop down, and nothing in the header. Yep, I'm in the right scope. I love magic.

Re: delete column on custom table?

Pradeep Sharma — Thu, 03 Mar 2016 18:13:52 GMT

Hey Pat,

If you to delete the table then you have to click on the collection record.

In case of column you have to click on each individual record to delete it.

Re: delete column on custom table?

chizhang — Tue, 28 Jun 2016 17:03:09 GMT

hello,

I meet the same issue with Pat: i cant have the option to delete customized column in the table i create.(i am in the right scope)

I dont understand your last reply, can you explain again if have a solution for this issue?

Thanks,

Chi Zhang

Re: delete column on custom table?

chizhang — Tue, 28 Jun 2016 17:04:16 GMT

hello, pat,

I have the same problem with you, did you finally find a solution for this bug?

Thanks,

Chi Zhang

Re: delete column on custom table?

Pradeep Sharma — Tue, 28 Jun 2016 17:38:09 GMT

Hi Chi,

Can you share screenshot of the column you are trying to delete. So if you go to the dictionary of the customized column you should see "Delete column" button on header of the screen.

Re: delete column on custom table?

chizhang — Tue, 28 Jun 2016 18:29:42 GMT

i have tried many methods but not work:

the option to delete is grey even when i have selected one :

no option to delete in the header dictionary entry of the column:

i am sure i am in correct scope.

Re: delete column on custom table?

chizhang — Tue, 28 Jun 2016 20:01:11 GMT

Hello,

Do you have any solution about this?

Thank you

Chi Zhang

Re: delete column on custom table?

Pradeep Sharma — Tue, 28 Jun 2016 21:56:26 GMT

Hi Chi,

Thanks for the screenshots. I am assuming assigned_to field is from one of the extended table i.e Task in this case.

You can delete the custom columns. Can you please create a custom field for testing purpose and check the behavior once.

Re: delete column on custom table?

chizhang — Tue, 28 Jun 2016 22:06:36 GMT

I create this "test" field, but still have no option to delete

Thanks

Chi Zhang

Re: delete column on custom table?

Pradeep Sharma — Tue, 28 Jun 2016 22:28:11 GMT

Hi Chi,

That's weird. That is not the expected behavior. Seems like bug to me.

Re: delete column on custom table?

davidb2000 — Wed, 20 Jul 2016 13:29:19 GMT

Same issue here...

I created a custom column as part of a custom (but extended table) and now can not delete the newly created custom column.

Re: delete column on custom table?

chizhang — Wed, 20 Jul 2016 21:55:31 GMT

Hello, David

I finally find it has something to do with the table id, my application was created based on template, when i create the table, the table id is not generated correctly with the application scope name as prefix, then made the costume table as a system table, resulting me unable to delete.

I tried to create my application from Scratch, and check if the table id generate with correct scope prefix, and then it works for me.

You can try this way. Good luck

Best,

Chi Zhang

Re: delete column on custom table?

clinton_hart — Fri, 16 Sep 2016 06:15:58 GMT

Same issue here.

Created a column on a table that extends Service Order (sm_order) in a scoped application. Unable to delete.

Re: delete column on custom table?

chris_lo — Sat, 08 Oct 2016 16:48:17 GMT

Please see my post from https://community.servicenow.com/thread/239427. I work with the support team that supports the scoped app functionality. The information provided may be useful for what you are seeing.