Object Grouping

Object grouping is meant to provide the developers an alternative way to organize the database objects they are working on. With object grouping you can categorize your objects for example by use cases they are used in or by tables they operate on or any other meaning you give to a group of objects.

Object grouping is very simple. Navigate to the database you will group the objects from and simply select and drag objects from the Object Explorer and drop these selected objects on a folder in the Object Grouping editor.

NOTE: Object Grouping needs PragmaSQLObjectGroup table and some procedures to operate. The table and needed procedures are created automatically by PragmaSQL in your database when you try to perform object grouping for the first time, of course you are asked for confirmation.

By persisting grouping information in your database you have the advantage of not loosing object grouping information during database restore operations. Object grouping goes in hand with your database and is meaningful for the appropriate version of your database.

Dropped objects are automatically deteceted by the Object Grouping editor while you navigate and displayed with an exclamation icon so that you can remove these objects from the object groups.

You can add help text for each object in rich text format, so that you can provide reference information to your co-workers.