Please use docs.servicenow.com for the latest documentation.
This site is for reference purposes only and may not be accurate for the latest ServiceNow version
Data Dictionary Tables
| Note: This article applies to Fuji. For more current information, see Data Dictionary Tables at http://docs.servicenow.com
The ServiceNow Wiki is no longer being updated. Please refer to http://docs.servicenow.com for the latest product documentation.
These tables provide data dictionary, data modeling, and entity relationship information:
- Tables [sys_db_object]: contains a record for each table.
- Dictionary Entries [sys_dictionary]: contains additional details for each table and the definition for every column on each table. Each row represents either a column on a table or a table.
- Field Labels [sys_documentation]: contains the human-readable labels and language information.
The Dictionary Entries [sys_dictionary] table, also called the System Dictionary, defines every table and field in the system. It contains information about a field's data type, character limit, default value, dependency, and other attributes.
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 (Personalize Dictionary in versions prior to Fuji).
To learn more, see System Dictionary.
The following image shows a filtered list of dictionary entries for the Incident table and the Task table, which it extends.
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.
For more information on the language file, see Relabeling a Table or Field.
The following image shows the language file filtered to display only labels on the Incident table.
The Tables [sys_db_object] table contains a record for each table in the database (Calgary release).
Access the Tables list by navigating to System Definition > Tables. Administrators can create a custom table, add or modify columns in a searchable and sortable embedded list, and define the auto-number format. To learn more, see Creating a Custom Table.
The following image shows a list of the tables that extend the Task table.