In ServiceNow, tables are fundamental components of the platform's database structure. A table consists of records (rows) and fields (columns) that store data.
1. Records (Rows) - Correct Option
A record is an individual entry in a table, similar to a row in a traditional database.
Each record represents a single entity (e.g., an incident, a user, a request).
Records are stored uniquely in the system and are identified by a Sys ID (a globally unique identifier).
2. Fields (Columns) - Correct Option
A field is an attribute of a record, like a column in a database.
Each field has a specific data type (e.g., string, integer, date, reference).
Fields define what type of information can be stored in a record.
Example: The Incident [incident] table
Sys ID
Number
Short Description
Caller
State
123abc
INC001
System crash
John D
New
456def
INC002
Network issue
Jane S
Open
Records: INC001, INC002 (each row is a record).
Fields: Number, Short Description, Caller, State (each column is a field).
Explanation of Incorrect Options:
B . Lists - Incorrect
Lists are a view of table data but are not a part of the table itself.
A list displays multiple records from a table but does not define the structure of a table.
C . Forms - Incorrect
Forms are user interfaces used to view or edit single records.
A form allows users to interact with the data stored in a table but is not part of the table structure itself.
Reference from Certified System Administrator (CSA) Documentation:
ServiceNow Docs: Tables and Records
ServiceNow CSA Study Guide - Understanding Tables, Records, and Fields
ServiceNow Product Documentation: List and Form Views