Create a database view

Create the database view.

Before you begin

Role required: admin.

Procedure

1. Navigate to All > System Definition > Database Views.

2. Select New.

3. Name the view as you would name a new table.

   The application converts capital letters to lower case and spaces to underscores.

4. Provide a label and a plural.

   The Label and Plural fields define how the database view is labeled in lists and forms. For example, give a database view with the label Duplicate installation the plural Duplicate installations.

5. Provide a description of the database view so that other users know its purpose.

6. Select Submit.

Result

The database view is created and accessible from the Database Views module.

What to do next

Add a table to the database view

Parent Topic:Joining tables using database views

Previous topic:Joining tables using database views

Next topic:Add a table to the database view