You can use the Properties view to
define the attributes for a new database object and then generate
and run a DDL script that creates that object in the database.
Before you begin
You must have the appropriate authority to an create object
in the database. A connection to the database must also exist.
About this task
The steps in this task assume that you are creating an object
in a database that is not a DB2® for Linux, UNIX, and Windows database.
You can create only one object at a time.
Procedure
- In the Administration Explorer, find
and expand the database that you want to create the object in. Right-click
a data object type folder and click . Alternatively, you can right-click a data object folder
in the Data Source Explorer and then click Create Object.
Tip: If the
Object List is
already open for the database, you can use the

(
Create a new object
icon image) icon in the
Object List to
create an object. An object that is the same type as the objects that
are being displayed is created.
- Select the schema to create the object in.
Important: Depending on the type of object that you are creating,
you are not always prompted to specify a schema.
The object
is displayed in the Properties view.
- Use the tabs in the Properties view
to define the attributes for the object.
For more information
about the attributes for an object, see Data object properties.
- When you are finished changing the attributes, click the
(Review and deploy
changes) icon. The Review
and Deploy dialog opens and displays the generated change
commands.
- Review the commands in the Review
and Deploy dialog and then specify how to deploy the changes
to the database.
Tip: You can modify and then
run generated commands in the SQL and XQuery editor.
You can also create a job and schedule when to run the generated commands
in the Job Manager.
Results
The generated commands are run on the database,
and the database object is created according to the attributes in
the
Properties view. The
SQL Results view
displays the results, including any errors that occurred.