All Products
Search
Document Center

Create views

Last Updated: Jun 08, 2019

This section describes how to create views in DMS.

Prerequisites

You have access permissions to DMS and you have logged on to the DMS console.

Procedure

  1. Select a target database and click Log On to Database.

  2. In the left-side directory tree, click and open the View tab to check the view in the selected database.

    Location of the view

  3. On the View tab, right-click and select Build in the menu. The New: View page appears, as shown below:

    Select Build in the menu

  4. Complete the definition of the view in the dialog box.

    The following example shows how to filter the records of the dmstest table whose values are even numbers, and how to generate the idand name fields.

  5. Click Save Change. DMS then generates the SQL statement used to create the view based on your settings. Click OK after you confirm the SQL statement. DMS then saves the view that you defined to your database.

  6. After the view is saved, it is added to the left-side directory tree. You can click and open the Views tab to display the view’s definition.

    Display the view definitions

  7. Right-click the view and select View Data to query data through the created view.

  8. You can perform view-related operations through the following menu options:

    • View Data
    • Create View
    • Edit View
    • Delete View
    • Refresh Views