When a table overflows and needs to create more fields, what should I do?

PMDM
Tera Contributor

Hi, I have some questions about tables in ServiceNow. When a table overflows and needs to create more fields, what should I do? Remember that since the table is overflowing, it is not possible to create a reference field.

2 REPLIES 2

Ankur Bawiskar
Tera Patron
Tera Patron

@PMDM 

what do you mean by table overflow?

Are you referring to the large number of records in that table?

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @PMDM 

 

I assume by "table overflow" you mean the table already has a lot of fields, and you want to add more. If that's the case, here's what you should do:

  1. Analyze existing fields: Ensure all existing fields are being used effectively. There may be some fields that have only been used once or twice throughout the entire lifecycle. These could potentially be reused or replaced with an alternative.

  2. Creating new fields: If new fields are necessary, evaluate which existing table is suitable for extension or if a custom table should be created from scratch.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************