Permissible limit of custom field creation on any table

Anand34
Tera Contributor

What is the maximum permissible limit of custom field creation on any table so that it may not affect performance ?

2 REPLIES 2

SumanthDosapati
Mega Sage
Mega Sage
  • The system can only have a maximum of 1000 columns per table. Although it is defined that 1000 columns is a specified limit, this does not 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.
  • Every table, regardless of storage engine, has a maximum row size of 65,535 bytes. Storage engines may place additional constraints on this limit, reducing the effective maximum row size.
  • The system can not have 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).

For more information on database limitations and general questions on tables in your ServiceNow instance, see KB0749585.

 

Reference : https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/administer/field-admi...

 

Mark as correct or helpful if applicable.

Regards,
Sumanth

Uncle Rob
Kilo Patron

Very interested to know what would risk getting you to that limit.