Data Definition view

 

In the Data Definition view, you can work locally with relational data objects.

The Data Definition view can hold:

• Local copies of data definitions that were imported from the Database Explorer view

• Designs that were created by running DDL scripts

• Designs that you created in the workbench

You can also export data definitions to another database that is installed either locally or remotely. With the Data Definition view, you can work on database objects and definitions even when you are not connected to your database server.

Using the Data Definition view, you can also:

• Rename logical objects

• Create DB2 UDB stored procedures and user-defined functions

• Define filters

• Drag and drop database objects from the Database Explorer view or within the Data Definition view

You cannot view logical files in the Data Definition view. Instead, use the Navigator view to see and work with logical files.

 

Parent topic

Overview of the Data perspective