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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-25-2020 09:57 AM
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).

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-25-2020 10:10 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2020 03:50 AM
Jeff do you happen to know where that is documented? I've been looking for that document. thx

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2020 04:12 AM
Omar,
I found it here.
https://www.servicenow.com/content/dam/servicenow-assets/public/en-us/doc-type/legal/custom-table-guide.pdf