Using Database Manager

The Database Manager enables the administrator to manage the database and perform related tasks in a single location. You can view separate tabs for Tables, Views, Functions, Triggers, Global Joins, and Audit. Each tab displays the records in a list view and Detail pane tabs to manage the information for a specific item. The Task pane contains tab specific tasks for each tab.

To access the Database Manager view, you can click Administration on the navigation bar and click Database Manager.

On this page, you can:

• Click Refresh to refresh the list information.
• Work with records in a grid. See Working with Grids in list views and tabs
• Click Hide Detail to hide the Detail pane.
• Manage Tables tab. See Using the database manager Tables tab
  • Add a new table. See Adding Tables in Database Manager
  • Delete a table. See Deleting tables in database manager
  • View the detail tabs for the selected table in the list:
    • CRM Details tab. See Using the database manager table CRM Details tab
    • Fields tab. See Using the Database Manager Table Fields tab
    • Indexes tab. See Using the database manager tables Indexes tab
    • Triggers tab. See Using the database manager table Triggers tab
    • Global Joins tab. See Using the database manager table Global Joins tab
• Manage Views tab. See Using the database manager Views tab
  • Add a new view. See Adding a View in database manager
  • Delete a view. See Deleting views in Database Manager
  • View the detail pane tabs for the selected view in the list:
    • CRM Details tab. See Using the database manager views CRM Details tab
    • Fields tab. See Using the Database Manager View Fields tab
• Manage Functions tab. See Using the Database Manager Functions tab
  • View the detail pane CRM Details tab for the selected function in the list. See Using the database manager functions CRM Details tab
• Manage Triggers tab. See Using the Database Manager Triggers tab
  • Add a new trigger. See Adding a Trigger in database manager
  • Delete a trigger. See Deleting a Trigger Definition in database manager
  • View the detail pane CRM Details tab for the selected trigger in the list. See Using the database manager trigger CRM Details tab
• Manage Global Joins tab. See Using the database manager Global Joins tab
  • Add a new global join. See Adding or modifying Global Joins in database manager
  • Delete a global join. See Deleting a Global Join in Database Manager
  • View the detail pane CRM Details tab for the selected global join in the list. See Using the database manager global joins CRM Details tab
• Use the Audit tab. See Using the database manager Audit tab
  • View the detail pane CRM Details tab for the selected view in the list. See Using the database manager global joins CRM Details tab