Add a column to [task] table

[Tepp]

Hi,

 [Task] table has a lot of “Extends tables”, isn't it common to add columns basically?

I think adding a column will almost always conflict the 8126 byte limit.

best regards,

[AbhishekGardade]

Hello Tepp,

NO issues if you want t create a field on task table.

Modifications made to the task table will be applied to all child tables. Be sure that the changes being made should apply to all of the child tables. Adding fields is a low-impact change, because the field can be hidden on tables that do not need it; however, deleting fields may cause unwanted data loss if the field is being used across tables. Note, when adding choice list entries to a choice list on the Task table, ensure the entry value is unique.

Some parts of a field definition can be changed in such a way as to not apply to all child tables using Dictionary Overrides.

4 Tips for creating custom tables in ServiceNow

https://community.servicenow.com/community?id=community_question&sys_id=21d7432ddb1cdbc01dcaf3231f96...

Dictionary Overrides - ServiceNow Wiki

Dictionary Overrides — ServiceNow ELITE.com

Please mark as Correct Answer/Helpful, if applicable.
Thanks! 
Abhishek Gardade

[Tepp]

Dear Abhishek Gardade

Thank you for your answer.

I understand that there is no problem without adding the field. But isn't it recommended that I add a column to the task table? When I actually added a column, I got an error message of 8126 bytes. Given the 8126 byte limit, I thought adding a column itself wasn't standard when there were many child tables.

best regards,

[AbhishekGardade · Accepted solution]

Here we go:

I got the HI ticket for this. this will definitely help you:

https://hi.service-now.com/kb_view.do?sysparm_article=KB0584932

I hope you have gone through this:

https://community.servicenow.com/community?id=community_question&sys_id=c6838365dbd8dbc01dcaf3231f96...

EDIT:

Do not add more than 10 medium-length or longer String fields to a single table. Attempting to save a large number of characters in 11 or more String fields can result in the following error: Syntax Error or Access Rule Violation detected by database (Row size too large (> 8126).

Please mark as Correct Answer/Helpful, if applicable.
Thanks!
Abhishek Gardade

[Tepp]

Dear Abhishek Gardade

Thank you very much!!