1.0
Table Of Contents
- VMware vFabric Data Director Administrator and User Guide
- Contents
- About VMware vFabric Data Director
- Updated Information
- VMware vFabric Data Director and vFabric Postgres Overview
- Managing Data Director Resources
- Managing Users and Roles
- Managing Organizations
- Managing Database Groups
- Managing Database Templates
- Managing Databases
- Cloning Databases
- Managing Database Entities
- Safeguarding Data
- Monitoring the Data Director Environment
- Managing Licenses
- Reconfiguring Data Director Networks
- Change the vCenter IP Address
- Reconfigure the Web Console Network Mapping or Network Adapter
- Reconfigure the vCenter Network Mapping
- Reconfigure the vCenter Network Adapter Settings
- Reconfigure the DB Name Service Network or DB Name Service Network Adapter
- Reconfigure the Internal Network or Internal Network Adapter Mapping
- Verify Network Settings in Data Director
- Data Director Troubleshooting
- Index
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.
What to do next
Examine the data in the view. See “Examine View Data,” on page 69.
Examine View Data
A view is a subset of related table data. After you create a view, you can examine the data in the view.
Prerequisites
Verify that a view is available. See “Create a View,” on page 68.
Procedure
1 Log in to Data Director as an organization administrator or user with database privileges.
2 In the Manage & Monitor tab, navigate to your schema, and click to select it.
3 Click the Views tab.
4 Double-click a view to select it.
5 Click the View Data tab.
Create a Constraint
Constraints enable you to reduce data entry errors by verifying data before inserting it into a table. Define
constraints on schema tables and columns from the Manage & Monitor tab.
You can create constraints when you create a table, or you can add them later. You can create the following
types of constraints.
n
Check constraint. Limits the values or value range that can be inserted in a column.
n
Unique constraint. Ensures that a column or set of columns is unique.
n
Primary key constraint. Uniquely identifies each row in a table. There can be only one primary key per
table.
n
Foreign key constraint. Points to a primary key in another table.
You enter SQL fragments to define a constraint.
Prerequisites
n
You are logged in to your organization as an organization administrator or user with database privileges.
n
The table on which to create the constraint already exists.
Chapter 9 Managing Database Entities
VMware, Inc. 69