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.

Note: Only the system administrator and users with the required permissions can access these features. These features are not available in Oracle environments.

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. 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. 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. 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. 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. 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
View the Audit tab. See Using the Database Manager Audit tab
- View the detail pane CRM Details tab for the selected database change or query performed in the Web Database Manager. See Using the Database Manager Audit CRM Details tab
Manage SQL Job Definitions. See Using the Database Manager SQL Job Definitions tab
- Add a new SQL job definition. See Adding a SQL Job Definition in Database Manager
- Delete a SQL job definition. See Deleting a SQL Job Definition in Database Manager
- View the detail pane CRM Details tab for the selected SQL job definition in the list. See Using the Database Manager SQL Job Definition CRM Details tab