Extending a table in ServiceNow

Anuja Jadhav1
Tera Contributor

What happens when we extend a table in ServiceNow.Is it tends to the redundancy?

3 REPLIES 3

Tony Chatfield1
Kilo Patron
Hi, you may need to clarify your question as it is not clear.

Aniket Sawant
Mega Expert

Hi,

Extending a table:

  • Links the new table to the extending table.
  • Creates system fields in the new table.
  • Creates one or more database tables to store the parent and child classes. The number of tables the system creates depends upon the extension model selected during table creation (Due to this it prevents redundancy).

 

for more information please go through the following link.

https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/table-administrat...

Please mark correct or helpful based on the impact.

Regards,

Aniket Sawant.

Anil Shewale
Mega Guru

Why extend an existing table instead of creating a new one

The ServiceNow platform comes with a robust and thoroughly tested collection of tables, fields, and related scripts to serve a wide variety of needs. For example, the Task [task] table provides functionality to manage the state of a request for work, including fields that store the state and reference fields that store who is working on it. The Configuration Item [cmdb_ci] table should be used as the base for any new CIs, while the User [sys_user] table contains details of people


Extending a base table incorporates all the functionality of the original table—including fields and scripts—into the new table. This inheritance is used to create major subcategories of data. Extending an existing table can save a lot of development and debugging time.

  

Determine if a new table or an extended table is more efficient

To decide whether to create a new table or extend an existing one, you may want to review the list of tables in the system. Navigate to System Definition > Tables, which displays not only whether the table is an extended table (Extends table column), but also whether it can be extended as well (Extensible column). In the example below, we've outlined the Alias table, which extends the Configuration Item table, and is extensible itself (Extensible = true). You can extend tables that are marked as extensible if they are in the same scope or if they allow configuration from other scopes.

 

To create an extended table, click New on the Tables list page, and select the table to extend from the Extends table search field. Note that this option is only available when creating a table, as it incorporates all of the fields of the original table and creates system fields for the new table.

 

Table development best practice

Instead of creating a new table, consider extending an existing one. If an existing table contains fields, attributes, and scripts similar to those you need, extend that table rather than creating a new one. Then modify the components of your extended table, as needed, to tailor its functionality to the new need.

 

If you are extending the Task table, you may need a Platform Runtime license to cover the new application you are building. Contact your ServiceNow representative for more details

Behind the scenes here at ServiceNow, the Knowledge Management team works closely with subject matter experts to disseminate critical information to our customers. We've found that certain topics come up frequently, in the form of best practices that can help you keep your ServiceNow instances running smoothly. This series aims to target those topics so that you and your organization can benefit from our collective expertise.

 

Mark my ANSWER as CORRECT and HELPFUL if it helped