Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table extension functionality allows sharing fields with a parent table. Administrators and developers extend tables during table creation.

Typically, tables are extended to create a set of records that share information with each other.

In the use case listed below, the Task table has multiple extensions:

Original tableExtended tables
Task
  • Incident
  • Service Request
  • Problem

A table extending another table is called a child table, and a table extended by it is called a parent table. A table can be both a parent and a child at the same time.

Table extending causes the following:

  • Cross-table linking between from the new table to the extending one;
  • System fields are created in the new table (like the sys_id field).


Necessary tools


Note

Role required: admin.

Instance administrators can use the All Tables tool to understand the relationships between the tables. To perform this, please complete the steps below:

  1. Navigate to System Definition → All Tables;
  2. Select the table you are interested in by typing its title in the search bar;
  3. Navigate to this table;
  4. The value in the Parent field is the title of the parent table, the one from which the current table is sharing fields.
Tip

Also, the parent table can be known when you are just in the tables list if you have previously configured your list layout to display the Parent field. For more information, please refer to the List layout article.