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. The following video provides an introduction to tables in ServiceNow. Getting Started with 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: Contains additional information that defines database elements. Table extension and classesExtended tables share both fields and records. Administrators and application developers can only extend tables during table creation.Create a tableAdministrators and application developers can create custom tables to store application data.Tables moduleThe Tables [sys_db_object] table contains a record for each table in the database.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.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.Restore deleted recordsSometimes, administrators can restore deleted records and references to those records.Create a table indexConstructing an effective index requires specialized knowledge in database architecture. If you do not have this expertise, you should consult someone who does.Task tableTask [task] is one of the core tables provided with the base system. Data dictionary tablesThese tables provide data dictionary, data modeling, and entity relationship information: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.Create a many-to-many relationshipMany-to-many relationships allow a list to point to a list of entries, rather than to single field. Database viewsA database view defines table joins for reporting purposes.