Table administration A table is a collection of records in the database. Each record corresponds to a row in a table, and each field on a record corresponds to a column on that table. Applications use tables and records to manage data and processes, such as Incident, Problem, and CMDB. Tables can extend other tables, creating parent tables and child tables. Administrators can use these tools for viewing and modifying the database structure: Tables module: provides a list of all tables in the database. Tables & Columns module: provides a list of all existing tables, with columns, column attributes, and indexes. Schema map: provides a graphical representation of the relationships between tables. Data dictionary tables: contain additional information that defines database elements. Create a tableAdministrators and application developers can create custom tables to store application data.Global default fieldsWhen you create a new custom table, several fields appear in the Table Columns embedded list. For all tables, required system fields are added automatically. You cannot delete or modify these fields.Activate restore deleted recordsAdministrators can activate the Restore Deleted Records plugin to enable this functionality.Create a many-to-many relationshipMany-to-many relationships allow a list to point to a list of entries, rather than to single field. For example, if a knowledge base article points to a list of related configuration items, it uses a related list. Not all lists can be used as related lists, however. For a list to be related to another list, a many-to-many relationship that refers to both tables must exist.Delete all records from a tableYou may decide to delete all the records on a table without deleting the table itself. For example, the administrator may want to delete all incidents on a test instance without deleting the incident table itself.Delete a tableAdministrators 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.Restore deleted recordsIn some cases, administrators can restore deleted records and references to those records.Restore a system tableServiceNow does not automatically track deletions from tables with a sys prefix. You can configure this behavior using these steps.Schema map for tablesThe schema map displays the details of tables and their relationships in a visual manner, allowing administrators to view and easily access different parts of the database schema.Tables moduleThe Tables [sys_db_object] table contains a record for each table in the database.Unique record identifierEach record in ServiceNow is identified by a unique 32-character GUID (Globally Unique ID) called a sys_id. The same sys_id value will never be generated twice, ensuring every record created in every table in every instance of ServiceNow in the world has a unique identifying value. Unique indexA unique index on a table guarantees that the index key contains no duplicate values and therefore ensures that every row in the table is unique in some way.Create a table indexCreate a custom index for a table.