Permissible limit of custom field creation on any table

Anand34
Tera Contributor

‎04-30-2022 06:06 AM

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

0 Helpfuls
  • 2,236 Views
2 REPLIES 2

SumanthDosapati
Mega Sage
Mega Sage

‎04-30-2022 06:28 AM

  • 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

‎04-30-2022 07:58 AM

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

0 Helpfuls