Administer > Database administration > System Definition

System Definition

The System Definition section of the System Navigator is an administrative tool that enables you to view and modify system tables and their components:

  • Fields
  • Keys
  • Links
  • Forms
  • Records

You can use the System Definition section if you have the Admin plug-in installed and the SysAdmin capability word enabled in your user profile. If you have SysAdmin rights, but the Admin plug-in is not installed, you can view the System Definition section but you cannot change it.

Administrators can do the following:

  • View, add, change, or delete forms, links, records, triggers, and Data Policy records.
  • Use the System Definition utility to add help or create an alias for any field.
  • View, add, change, or delete database dictionary definitions.
  • View, add, change, or delete SQL mappings to a back-end RDBMS.
  • Open, reset, regenerate, and copy database dictionary definitions.
  • Add, change, copy, and delete keys and fields.
  • Count the number of records in logical tables

Each time you right-click a node in the System Definition section, the System Navigator displays a Context menu of available actions.

System Definition utility

The System Definition utility is a graphic view of existing table elements and properties and a quick way to define new tables. It enables you to accomplish the tasks traditionally handled by the database dictionary utility. The System Definition utility has two tabs: tables and fields. Service Manager displays SQL mapping information only when mapping information is available. Each time you double-click any table in the System Definition area of the System Navigator, the System Definition utility displays the Table tab first. You can access the other tabs by clicking the labeled tabs or links in the Editor.

If you change a table element, an asterisk marks the table and the element in the System Navigator until you click Save.

Access the System Definition utility

Applies to User Roles:

System Administrator

To access the System Definition utility:

  1. From the System Navigator, click System Definition.
  2. Expand the name of any table in the record list.

    Note: You can type the first letter of a table name to jump to that alphabetic section. For example, type o to jump to the oncall table.

 

Related topics
Editing System Definition nodes

Access field help from the System Navigator