2.7

6 To perform the Vacuum and Analyze operations, click OK.
7 (Optional) To perform the Vacuum operation, uncheck the Analyze checkbox and click OK.
To include the Full or Freeze operations with the Vacuum operation, check those checkboxes.
8 (Optional) To perform the Analyze operation, uncheck the Vacuum checkbox and click OK.
Create a Schema
After you create a database, you set up its entities, starting with the database schema. You create schemas from
the database tab.
You create database schemas from the database tab next to your organization
Prerequisites
n
Verify that a database exists in which you can create a schema.
n
Log in to Data Director as a user with database privileges.
n
Click Console to open the database in a new tab.
Procedure
1 Right-click Schemas in the left pane and select Create Schema.
2 Enter the schema information.
3 Click OK.
Data Director creates the database schema.
What to do next
Create schema entities such as tables, triggers, users, and so on.
Create a Table for Schema Data
After you create a schema, you create tables to contain the schema's data.
Prerequisites
You are a database administrator or application developer setting up a database.
You created a database and a schema, and are in the Console.
Procedure
1 In the left pane, click the Schemas arrow to expand it.
2 Right-click the schema and select Create > Table.
3 Type the table name, fill factor, and comment.
4 Click Next.
5 Click Add to add a column.
a Type the column name, and select the column type..
Depending on the column type, you can specify a length or precision, a default value for the column,
and add a comment.
b If users must enter a value for the column, select the Not Null check box.
c If the column is a primary key, select the Primary Key check box.
Chapter 11 Managing Database Entities
VMware, Inc. 143