Skip to content
Tutorials Center
My learning

Topics

Lesson 13 of 39 ยท Tables and Data Model

Dictionary and Schema Tools

Use the data dictionary, the schema map, the Tables module, field labels and dictionary overrides to understand and shape any ServiceNow table without guessing.

ServiceNow documents its own data model inside the instance. The dictionary records every table and column, the schema map draws the relationships, and dictionary overrides let a child table change what it inherited. Knowing these tools lets you answer "what is this field called, what type is it, and where does it point?" in seconds.

The dictionary tables

Three system tables describe the data model:

Table Describes Open with
sys_db_object Tables System Definition > Tables
sys_dictionary Columns (the dictionary entries) System Definition > Dictionary
sys_documentation Labels, hints and help text per language The label of a field, via Configure Label

A dictionary entry holds the column name, type, max length, mandatory, read-only, default, reference table, attributes and more. You can open one from a form: right-click a field label and choose Configure Dictionary. The other menu entries are:

  • Show - table.column: displays the field's backend name for use in scripts.
  • Configure Label: change the label text for a language.
  • Personalize Choices: appears for choice fields so you can see/change choices.

To search the dictionary, open sys_dictionary.list, filter Table is incident and read the columns. Use the list's Group By > Type to see how many references or strings the table has.

The schema map

Open System Definition > Tables, open a table, and choose the Show Schema Map related link (or Schema Map in the context menu). The map draws the table in the middle, its parent and children, and the tables it references or that reference it. You can choose how many levels to show, which relationship types to include (references, many-to-many, extends) and click a table to re-center.

Use it to:

  • See which tables point at a table before you delete a column.
  • Explain a design to a colleague.
  • Find the table behind a form that has many references.

The schema map is a read-only visual. Editing still happens in the Tables and Dictionary modules.

Field labels versus names

Each column has a label (translatable, shown on forms and lists) and a name (stable, used in code). Two columns on different tables can share a label. Hint text and Tooltip (the question mark help) come from sys_documentation. When writing scripts always confirm the name; do not guess it from the label ("Assigned to" is assigned_to, but "Business service" is business_service, and "Configuration item" is cmdb_ci).

Python Dictionary lookup (stand-in)

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Dictionary overrides

When a child table inherits a column, you may need a different behavior in the child: a different default, a different mandatory flag, a different reference qualifier. A dictionary override is a record in sys_dictionary_override that changes selected properties for one column on one child table without touching the parent.

Example (illustrative): the task table has a priority column. Suppose you want new changes to start at priority 4. An override on change_request sets its default value to 4, while the parent task and the other children are unchanged.

Where to create one: open the child table's column (in the Tables module, look at the inherited columns) and choose Override options, or open System Definition > Dictionary Overrides and press New. The override form shows checkboxes (Override mandatory, Override default value, Override read only, Override reference qualifier, and so on); tick the aspect you want and set the value.

Python Override resolution (stand-in)

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Practical routine for an unfamiliar table

  1. Open the form, then Configure > Table to find the table name.
  2. In the Tables module read the Extends value and Columns.
  3. Use Show Schema Map to see what references it.
  4. Check Dictionary Overrides if a column behaves unlike the parent.
  5. Read Business Rules, Client Scripts, UI Policies and ACLs (related lists or their modules) filtered by that table.
  6. Test with a throwaway record before editing anything.

Changing a column's type or deleting a column is not a casual action: you may lose data and break scripts, reports and integrations that name it. Check the schema map and search the system for the column name first (System Definition > Scripts and the global Text search).

Check your understanding

Quick check ยท 3 questions

of 3 answered You scored / 3 ยท perfect!

  1. 1. Which table stores the definition of each column?

    sys_dictionary has one dictionary entry per column; sys_db_object describes tables.
  2. 2. What does a dictionary override do?

    An override adjusts inherited properties such as default or mandatory for a child table without changing the parent.
  3. 3. What is the schema map for?

    It draws the table with parents, children and references so you can understand the model.

Summary

  • sys_db_object, sys_dictionary and sys_documentation describe tables, columns and labels.
  • Use Configure Dictionary and Show - table.column to learn backend names.
  • The schema map shows relationships; overrides adjust inherited columns per child.
  • Investigate before changing a column.

Next: Forms and Form Layout