2.5

6 (Optional) In Constraints, select the type of constraint, Foreign key, Unique, or Check, that applies to the
new column.
You can create foreign key constraints only if the schema has more than one table.
a Click Create.
b Enter the conditions for the constraint, and click OK.
c Click Next to continue, or click Finish to create the table.
7 (Optional) In the Auto Vacuum Settings, select settings for removing stale data from your table,
The default settings work well for most environments. For information about autovacuum, see the
documentation on the Postgres.org site for Postgres databases, or the documentation on the Oracle.com
site for Oracle databases.
8 Click Finish to create the table.
Data Director creates the table.
Create a View
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.
Prerequisites
Verify that the table on which to create the view exists.
Procedure
1 In the left pane, click the Schemas arrow to expand it.
2 Right-click the schema and select Create > View.
3 Enter the view properties.
a Type a unique name in the Name text box.
If the name is case-sensitive, select the Case sensitive check box.
b (Optional) To restrict who can modify the view, select an owner for the view definition from the drop-
down menu.
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"
4 Click OK.
The view appears in the left pane under the Views icon.
What to do next
Examine the data in the view. See “Examine View Data,” on page 125.
VMware vFabric Data Director Administrator and User Guide
124 VMware, Inc.