Generate a CRUD MATRIX to Review CRUD Operations (Create, Read, Update, Delete)

August 2020 Update: Views

CRUD matrix now supports generating CRUD operations on views. The resultant matrix displays CRUD operations on views as well as operations on the tables for which the views are generated.

December 2019 Update: Table Synonyms

Until now, CRUD matrix displayed CRUD operations on selected tables, columns, procedures, and functions. It is now possible to generate a CRUD matrix on table synonyms to show the objects using them.

July 2019 Update: Procedures and Functions

It is now possible to select procedures or functions to generate a CRUD matrix, to show which tables they are using, and how they access them. Until now, it was only possible to select tables, to show the objects using them. Basically, it now works both ways.

Visual Expert can generate a CRUD matrix - to analyze CRUD operations in your code (Create, Read, Update, Delete). 

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):

 

List the components accessing tables or columns

  • Review high-level references between database and code.

  • Design and update your database schema

  • Estimate the complexity of your code, and the effort to maintain it.

  • Identify tables never updated, tables deleted by multiple programs etc.

  • and more...

Try Visual Expert

Download a Free Trial to Analyze your PowerBuilder, Oracle or SQL Server Code

How to generate a CRUD matrix?

  1. Open your Visual expert project

  2. You can create a CRUD matrix for the following selections:
    1. Tables to show which objects are using them.

      Create CRUD Matrix

    2. Select functions or procedures to show which tables they are using:

      Select functions or procedures for CRUD Matrix

    3. Select views to show the tables they are using as well as their CRUD operations:

      Select views to map tables in CRUD Matrix

  3. Next, click on ‘Create a CRUD matrix’ in the navigation bar.

    Generate a CRUD matrix in Visual Expert

  4. A message confirms that the operation has been completed successfully.
    Click ‘Open’ to access the CRUD matrix.

    Access the CRUD matrix in Visual Expert

  5. The CRUD matrix opens in Excel. You can edit, share, print it as you like.

    Generate a CRUD matrix to analyze CRUD operations

Watch a Video

PowerBuilder, Oracle, SQL Server, Code Exploration, VE 2017