A view is a subset of related table data. For example, if you have a table that contains the locations of all corporate offices throughout the world, you can create a view of all the offices in Europe, in California, or Brazil. You create views from the Views tab in the schema pane.

Verify that the table on which to create the view exists.

1

Log in to Data Director as an organization administrator or user with database privileges and select a database.

2

Click the Views tab.

3

Click the plus icon to create a view.

4

Enter the view properties.

a

Enter a unique name in the Name field. If the name is case-sensitive, select the Case sensitive check box.

b

(Optional) To restrict who can modify the view, use the drop-down menu to select an owner for the view definition.

c

Enter a SQL query to define the view.

For example, if you are creating a view of your office_locations table named China Offices, you might enter a query similar to the following to select all the office locations in China.

select office_name, addr1, addr2, addr3 from office_locations where country="China"
5

Click OK.

The view appears in the left pane under the Views icon.

Examine the data in the view. See Examine View Data.