Online Documentation for SQL Manager for DB2

Using context menus

The context menu of the diagram area contains a number of items available in the Navigation bar and toolbars and allows you to:

• select all objects in the diagram area;
• select all headers and/or fields in the diagram area;
• adjust diagram zoom for optimal representation: zoom in, zoom out, select rectangle to fit, fit model, specify a predefined zoom value;
• set the cursor mode to Select or create a new table, view, procedure, function, relation, virtual relation, or comment;
• configure the grid: draw grid, snap to grid;
• adjust the diagram style: draw entities icons, draw attributes icons, draw only names of entities, draw foreign key names;
• perform Reverse Engineering;
• extract metadata of the diagram objects to SQL Script Editor;
• view/edit diagram options.

The context menu of an entity contains items for working with the object and allows you to:

• edit the object using its editor (Table Editor, View Editor, Procedure Editor, Function Editor);
• create a new object using its editor (New table, View Editor, Procedure Editor, Function Editor);
• drop the object from the database;
• show/hide object subitems (for tables) or the entire object (for views, procedures, functions);
• remove the object from the diagram.

The context menu of a field contains items for working with the object and its fields and allows you to:

• edit the selected field using its editor (Field Editor);
• create a new field;
• drop the selected field;
• edit the object using its editor (Table Editor, View Editor);
• create a new object using its editor (New table, View Editor);
• drop the object from the database;
• show/hide object subitems (for tables);
• remove the object from the diagram.