Task Table

[raju6745]

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?

[raju6745 · Accepted solution]

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

One has- 70 

Second one- 71

[Pranesh072]

You are referring wrong table. 

Task table - /sys_db_object.do?sys_id=task&sysparm_refkey=name&sysparm_domain_restore=false&sysparm_referring_url=task_list.do

Additional column maybe the collection type which is not available on table view but visible on the sys_dictionary table.

[raju6745]

Thank you for your reply let me check 

[AkashM915112357]

@raju6745 

Hello,

Can you provide the table name to get better understanding ? 

[raju6745]

"Task table"we are talking about 

[Juhi Poddar]

Hello @raju6745 

By default there are 71 columns in a task table.

Please refer to the screenshot below from a new instance:

Hope this helps!

"If you found my answer helpful, please like and mark it as an "accepted solution". It helps future readers to locate the solution easily and supports the community!"

Thank You

Juhi Poddar