Data dictionary tables

  • Release version: Zurich
  • Updated July 31, 2025
  • 2 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Data dictionary tables

    The data dictionary tables in ServiceNow provide detailed information about the tables, fields, and labels within your instance. These tables enable administrators to manage and customize the data structure, view metadata, and control how data is stored and presented.

    Show full answer Show less

    Key Components

    • Tables [sysdbobject]: Contains records for every table in the database. Administrators can create custom tables, modify existing ones, manage columns, define auto-number formats, extend tables, and create related modules. Features include launching schema maps, accessing dictionary entries, navigating default views, and deleting all records in a table.
    • Dictionary Entries [sysdictionary]: Defines each table and field's attributes such as data type, character limit, default values, and dependencies. Administrators can view and configure dictionary definitions to understand and modify field properties.
    • Field Labels [sysdocumentation]: Stores labels and hints for tables and columns, supporting multi-language configurations. Administrators can view and update field labels directly from forms or via the Language File list.

    Practical Benefits for ServiceNow Customers

    • Enables comprehensive management of the database schema, ensuring data consistency and integrity.
    • Allows customization of tables and fields to fit specific business needs.
    • Facilitates easy access to metadata and label information, improving user interface clarity and localization.
    • Supports administrators in maintaining and configuring instance data structures efficiently through intuitive navigation and management options.

    Access details related to tables, columns, and field labels in your instance.

    Tables

    All of the information on an instance is stored in tables, which consist of a series of records. The record in turn holds a series of fields that hold the individual bits of data and can be viewed either as a list or a form.

    The Tables [sys_db_object] table contains a record for each table in the database.

    Access the Tables [sys_db_object] table by navigating to System Definition > Tables. From the Tables list, an administrator can create a custom table, or select an existing table to view table details. In the table form, an administrator can access table administration options.

    • View, add, or modify columns with a searchable and sortable embedded list, define the auto-number format, make the table extendable by other tables, and create modules for the table.
    • Launch a schema map for a table by clicking the Show Schema Map related link.
    • Open the dictionary entries for the table by right-clicking the form header and selecting Show Dictionary Record.
    • Navigate directly to the default list or form view for the table by clicking the Show List or Show Form related link.
    • Delete all records from a table by clicking the Delete All Records.
    The following image shows a list of the tables that extend the Application File table.
    Figure 1. Tables
    A list of tables that extend the Application File table.

    Dictionary Entries

    The Dictionary Entries [sys_dictionary] table, also called the System Dictionary, defines every table and field in the system. It contains information about data type, character limit, default value, dependency, and other attributes of a field.

    Access the system dictionary in one of these ways:
    • To see the system dictionary list view, navigate to System Definition > Dictionary.
    • To view particular dictionary definition, right-click the list header, form header, or field label, and select Configure Dictionary.
    The following image shows a filtered list of dictionary entries for the Incident table and the Task table, which it extends.
    Figure 2. Dictionary Inc Task
    A filtered list of dictionary entries for the Incident table and the Task table.

    Field Labels

    The Field Labels [sys_documentation] table, also called the Language File, contains information about the labels and hints for each table and column in the system.

    Access the language file in one of these ways:
    • To see the list view, navigate to System Definition > Language File.
    • To see the field label for a particular field, right-click the field label on the form.
    The following image shows the language file filtered to display only labels on the Incident table.
    Figure 3. Field Labels
    A list showing field labels on the Incident table.