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

Vishwa Pandya19
Mega Sage

Hi @raju6745 ,

 

Go to the Dictionary table > Put in the Filter "Table Is Task AND Created By Is <Your Name>"
You should be able to find the record you created.

 

If my answer helped you in any way please mark it as correct or helpful.

Hi @Vishwa Pandya19 - Please note i am using admin instance given by SNOW itself

 as per given solution i have tried to check but nothing i have seen in created records PFA

Di Zhang
Tera Guru

Search the column start with "u_" in task table, it will be custom fields. 

No any coloums is starting with U_ in task table still coloums are showing 71