Extending a table in ServiceNow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-05-2020 01:22 AM
What happens when we extend a table in ServiceNow.Is it tends to the redundancy?
- Labels:
-
Scoped App Development
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-05-2020 01:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-05-2020 01:27 AM
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.
Please mark correct or helpful based on the impact.
Regards,
Aniket Sawant.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-05-2020 01:39 AM
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