Generate a CRUD Matrix from a Selection of Objects

Since Version 2017, Visual Expert can generate a CRUD matrix - to analyze CRUD operations - for a given selection of tables. 

As a result, you can see which table is accessed by which objects (procedures, functions, etc.) with the type of access for each object: Create, Read, Update, Delete.

Visual Expert 2019 adds the possibility to generate a CRUD matrix for a selection of objects (instead of starting from a selection of tables).

Simply select some objects, and click on “CRUD Matrix”.

generate crud matrix from selection of objects

An excel sheet will open documenting the CRUD operations - you can ignore the excel warning about the file format:

generate crud matrix from selection of procedures or functions

Learn more about Generating CRUD matrix from your code with this tutorial

Visual Expert 2019, Oracle, SQL Server, PowerBuilder