Data Management

In the previous chapters, we learned the basics of the ServiceNow platform and how to perform user administration. Let us now dig deep into the concept of data dictionaries to understand how data is stored and segregated in ServiceNow. As part of your project at ABCD, Inc, you are supposed to create a custom table to manage all point-of-sale locations.

In this chapter, we will learn how to create a new table from scratch, extend existing tables, and add fields (or columns) to new or existing tables. We will also look at the structure of existing tables, such as task and cmdb.

Managing tables and columns is one of the most common jobs that administrators and developers have to perform when working on the ServiceNow platform. As ServiceNow is a cloud-based platform, direct access to the database isn't provided to customers. However, the ServiceNow platform features various modules that can be used to create and manage tables and columns.

In this chapter, we will cover the following topics:

• Database structure overview
• Using the Tables & Columns module
• Viewing the schema map
• Creating a new table
• Adding columns to a table
• Modifying column properties
• The Task table structure
• Creating a table that extends the Task table
• The configuration management (cmdb_ci) table
• Creating a new CMDB class