Maximum number of fields on a table

[Enrique Tabalon]

We currently have 90 fields/column on a custom table that was extended from task. The business needs to add like 50 more fields.

Is there a limitation on maximum number of fields allowed on a table? 

Your input is greatly appreciated.

Thank you!
Enrique

[Mark Roethof · Accepted solution]

Hi there,

Its not really about the number of maximum fields, its more the maximum row size. 140 fields like you are mentioning doesn't have to be an issue (I've seen more than double), than can be... for example when adding too many multiline string fields. It is a ServiceNow best practice to not have more than 10 of those (is really a low number, though I have seen it go wrong at a customer having 50 of those, causing serious database corruption and ServiceNow Support needed).

[Sandeep Rajput]

@Enrique Tabalon According to ServiceNow docs '

• The system can only have a maximum of 1000 columns per table. Although 1000 columns is a specified limit, this limit doesn't mean you can physically have 1000 columns within a table. The number of columns within a table is defined by the database used in the ServiceNow datacenter, not by the Now Platform.

Source: https://docs.servicenow.com/bundle/washingtondc-platform-administration/page/administer/field-admini...

'

[Mark Roethof]

@Enrique Tabalon My comment was on the 2nd and 3rd bullet of this image. I feels those are more important than 1000 columns per table. And to be honest, 1000 columns... something horribly went wrong in designing the table/app/etc if you have soo many fields 😅

[Rajesh_Bhise]

Hello @Enrique Tabalon,

You can add upto 1000 fields for any table in ServiceNow as per below design given by SNOW.

But I would suggest to create sections and add fields in it so that your form loads properly. Additionally you will be categorized fields more conveniently than random fields on the form.

ServiceNow recommends to keep minimum fields on the form so that backend configuration works properly within form load or database update. This will help to improve system performance as well.

Thank You,

Rajesh