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.