You can create objects by using the Administration Explorer, Object List, or Data Source Explorer. You can alter and drop objects by using the Object List or Data Source Explorer.
When you create or alter a database object, you use the Properties view to set or alter the attributes of the object. From the Properties view, you can then open the Review and Deploy dialog, where you can review and run the generated DDL that creates or alters the object. Similarly, when you drop an object, the Review and Deploy dialog opens, where you can review and run the generated DDL.
Database Server | Administration Explorer and the Object List | Data Source Explorer |
---|---|---|
IBM® DB2 for i | - | X |
IBM DB2 for z/OS® | X | X |
IBM Informix® Dynamic Server | - | X |
Oracle Database | - | X |
Sybase Adaptive Server Enterprise | - | X |
For information about the versions and releases that are supported for these database servers, see the techdoc for System requirements for IBM Data Studio.