Is there a maximum number of columns allowed in a table? If so, does this vary per license type?

Diana Lewis1
Mega Expert

A customer asked if there was a maximum number of columns allowed in the CMDB base table. I could not find any reference to maximum columns, for CMDB or other table. They also wanted to know if there was any license consideration regarding number of columns (like there may be for number of custom tables).

3 REPLIES 3

Jeff Currier
ServiceNow Employee
ServiceNow Employee

I believe the ultimate limit is constrained by the backend database.  Since this is MySQL, I believe that 4096 is the field limit per table.  However, the practical limit is much less.  In most cases, it is better to use related tables as opposed to adding hundreds of fields to one table.

For the number of fields, the limit of custom fields is 50 for custom table and exempt tables.  Since CMDB tables are exempt, the limit would be 50 for custom fields from a license perspective.  However, you should consult your account team about licensing specifics for your account.

Jeff do you happen to know where that is documented? I've been looking for that document. thx

Omar,

I found it here.

https://www.servicenow.com/content/dam/servicenow-assets/public/en-us/doc-type/legal/custom-table-guide.pdf