Task Table

raju6745
Tera Contributor

How can i find what coloum i have added extra in TaSK Table?

AS we all know task table has 70 coloum by default but when i am checking in my instance there is 71 how can i check created coloumn by me and how can i delete it?

2 ACCEPTED SOLUTIONS

@Juhi Poddar - I have two instances and both has different different columns in task table 

 

One has- 70 

Second one- 71

View solution in original post

Hi @raju6745 

Why not download the task table data as an Excel file, check for the extra field, and simply remove it?

FYI: Task table attributes may vary if a new plugin is installed that uses the Task table as a base. So, in another instance, the plugin might be installed, but it's not present in the first instance."

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

26 REPLIES 26

then why this is showing 71 column?

it should be 70 if i am not wrong

I simply don't know if that figure of 70 is correct or not. Maybe it's not ... also it could change depending on what plugins have been added, etc. 

Shall i consider 70 coloums in task table is Correct?

I honestly don't know. I'm away from my PC atm, otherwise I'd log into one of my instances and check what number I got. 

No, it is determined by which plugin your installed.