Total number of fields possible on one form or table

[Umesh Bade3]

Total number of fields possible

[Slawek_Radziewi]

https://dev.mysql.com/doc/mysql-reslimits-excerpt/5.7/en/column-count-limit.html

[Paul Curwen]

Hi Amesh,

Remember ServiceNow is not Excel!! so keep your forms light and simple to ensure they load fast and can be easiliy traversed by the user. 

Regarding the max. Table columns I believe ServiceNow uses MariaDB (used to use MySQL). MariaDB is basically a fork of MySQL and I think the same limits apply....

There is a hard limit of 4096 columns per table, but the effective maximum may be less for a given table. The exact limit depends on several interacting factors.

Every table (regardless of storage engine) has a maximum row size of 65,535 bytes. Note though that some storage engines may place additional bespoke constraints on this limit, reducing the effective maximum row size.

The maximum row size constrains the number\size of columns as the total length of all columns cannot exceed this size.

If you are getting anywhere near this limit you probably need to think your design again 🙂

Regards,

Paul