Schema Browser (Revision #21)

Schema Object Status: When the status of views, functions and procedures becomes invalid in Oracle, DB2 LUW and DB2 zOS, the Schema Browser icons for those objects changes to include a square red icon overlay. When the errors have been corrected, and the Schema Browser refreshed, the red overlay icon is removed indicating that the schema object is now valid. The icon overlays also appear in the Details View. Object status indicators mark Oracle (Views, Triggers, Packages, Procedures, Functions, Package Bodies, Synonyms) DB2 LUW (Synonyms, Functions, Packages, Procedures, Triggers, Views) and DB2 zOS (Synonyms, Packages, Triggers, Views) objects when invalid.

Schema Object Status

Icons for Constraint Types:  Constraints in the schema browser now have icons specific to the type so you can quickly identify the types of constraints on a table.

Constraints Icons

Schema Object Sorting: Sorting is available for Columns from the Schema Browser right click context menu. Objects in the Schema Browser are now sorted alphabetically. When new objects are added (such as new tables), they sort automatically.

Schema Object Sort	Tables Sorted

Schema Folder Grouping: In the Advanced Server Registration tab there is an option called "Use Schema Folder Grouping" with possible options of Default, Yes and No. It applies to all vendors that have "database" as a schema object: MS SQL Server, Sybase ASE, Sybase Anywhere, Sybase IQ, Informix, nCluster, PostgreSQL.

Folder Grouping

Visual Edit Prompt: When visual edits have been made, users can disable the "cancel" prompt to speed the editing process.
File -> Options -> General -> General:[Prompt to discard changes in Visual Editing dialogs]. The default setting is to prompt users.

Visual Edit Prompt

Create/Drop Schema GUI for :  A new option to Create/Drop Schema is included for Derby, DB2 LUW, DB2 iSeries, MS SQL Server, PostgreSQL and nCluster

CREATE and DROP GUI