Choose your SQL server:
AnySQL
MySQL
MS SQL Server
Oracle
PostgreSQL
SQLite
Firebird
SQL Anywhere
DB2
MaxDB

Subscribe to our newsletter
Partners
Testimonials
Ilakshi Rathod : "This tool is just wonderful. I have never seen any tool for DB2. This tool provides very good features which helps in ease us work as well as quick resolution of any errors.".
Jeff Rule: "I have to tell you I am really impressed. I have never had a software company turn around a bug fix like this so fast. I have been doing database work for over 20 years and that has never happened.".

More

Add your opinion

SQL Maestro Group / Products / DB2 / DB2 Maestro / Documentation

DB2 Maestro online Help

Prev  Return to chapter overview Next 

Sorting database objects

Object Browser represents database objects in a grid. The object kind to display is defined on the top of the Navigation bar. The columns correspond to the objects properties and rows correspond to the objects. Click the column caption to sort objects by the values of this column in the ascending or descending mode. The navigation buttons allow you to open current object editor, create new or drop the existing one.

 

As Object Manager the browser allows you to operate on several objects at a time. You have an opportunity to select a batch of objects and after the object group is selected, you can operate on it (e.g. drop several objects at once) as if it were a single object.

 

The unique feature of the DB2 Maestro is an opportunity of drag-and-drop operations between Object Browser and SQL Editor, SQL Script Editor. After the action objects are represented in SQL Editor as SQL queries (if they contain data) or as their full name in the database otherwise. SQL Script Editor displays the objects as SQL definition.

 



Prev  Return to chapter overview Next