---
sourceDocument: Xanadu ServiceNow AI Platform Administration
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/platform-administration

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu ServiceNow AI Platform Administration

ft:clusterId :

    - platadm

bundleId :

    - platadm

workflow :

    - Platform


---

# Managing tables and indexes

# Managing tables and indexes {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

Administrators can modify the database structure using table administration tools.

## Custom tables and fields {#using-table-administration__section_mbr_q52_3cc}

Administrators can add custom tables, define fields, and manage field labels. Administrators can also delete custom tables that aren't needed or delete all the records in a table without deleting the table itself.

## Dictionary entries {#using-table-administration__section_pt4_53g_3cc}

The system dictionary is a table, called Dictionary Entry `[sys_dictionary]`, that contains details for each table and defines every column within each table in an instance. Administrators can modify tables and
fields in the system dictionary, which subsequently define the lists and forms that users access throughout the instance.

## Dictionary attributes {#using-table-administration__section_g5m_242_3cc}

Dictionary attributes define global behavior for fields. An administrator applies attributes directly to the dictionary entry to control various aspects of how the table or field behaves across the entire system.

## Dictionary overrides {#using-table-administration__section_cy4_qhg_3cc}

Dictionary overrides enable administrators to override field settings on extended tables. Dictionary overrides enable administrators to customize the behavior of a field for a specific table that inherits from another table.
Overrides are used to change the inherited dictionary attributes on child tables without affecting the parent table or other child tables.

## Table flattening {#using-table-administration__section_yg3_dkf_3cc}

With table flattening, the Task \[task\] table and Base Configuration Item \[cmdb\] table have a hierarchy of related tables where one or more child tables extend from a parent table.

The extension model does not affect how the tables appear or function in the instance. All table functionality, including database views, remains unchanged by the extension model.

## Table indexes {#using-table-administration__section_cwy_kv2_3cc}

An index puts unordered tables into order, and efficiently speeds up queries to columns in your tables, by creating pointers to where information is stored in your database. Administrators can add indexes to access table data more
easily.

## Many-to-many table relationships {#using-table-administration__section_z3b_5jg_3cc}

Many-to-many (M2M) table relationships enable administrators to associate records between two tables in a bidirectional and flexible manner. This relationship type is used to create links between records where each record from one
table can relate to multiple records in another table, and vice versa.
* **[Create a table](https://servicenow-prod.fluidtopics.net/ytA17q3swveAExCTp20wmQ)**   
  Administrators and application developers can create custom tables to store application data. After you create a table, you can also modify field types and field labels.
* **[Deleting custom tables](https://servicenow-prod.fluidtopics.net/pl_2z4Ew0M9kLUZOFoAdMQ)**   
  Administrators can delete custom tables that are no longer needed. For example, delete a table from an application that is under development because the business requirements change.
* **[Modify dictionary entries](https://servicenow-prod.fluidtopics.net/bHhNzfdSmx1ltB2o4HpOag)**   
  Modify dictionary entries by configuring a field on a form or from the Dictionary module.
* **[Altering tables and fields using dictionary attributes](https://servicenow-prod.fluidtopics.net/W62P_HvztvVqWYI5duwoKQ)**   
  Dictionary attributes alter the behavior of the table or field that the dictionary record describes. Administrators can add or modify dictionary attributes.
* **[Dictionary overrides](https://servicenow-prod.fluidtopics.net/Q4hINOapX8jcIphpqgbz_w)**   
  Dictionary overrides provide the ability to define a field on an extended table differently from the field on the parent table.
* **[Table flattening](https://servicenow-prod.fluidtopics.net/wvwxaMuHCt2VXWgWESqj0w)**   
  Table flattening stores a hierarchy of related tables as one table in a relational database.
* **[Viewing table references and extensions](https://servicenow-prod.fluidtopics.net/TFWFPZctaar_WohEyqeaQQ)**   
  View table relationships in a visual manner using the schema map.
* **[Create a table index](https://servicenow-prod.fluidtopics.net/w8kbQwpMpCH1Qn9dAI6jpA)**   
  Build indexes to access the data held in your tables more easily.
* **[Drop a custom index](https://servicenow-prod.fluidtopics.net/UdKLEF~wo_eLd_o4ULPGtQ)**   
  Remove a custom index by dropping it from a table.
* **[Create a many-to-many table relationship](https://servicenow-prod.fluidtopics.net/Cm0P7RQJbt7QKf5LcKDTSw)**   
  Create a bi-directional relationship between two tables, so that the related records are visible from both tables in a related list.