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

July 2019 Update: 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 Now

How to generate a CRUD matrix?

  1. Open your Visual expert project

  2. You can either:
    1. Select tables to show which objects are using them.
    2. Select functions or procedures to show which tables they are using:

    generate-a-crud-matrix-to-analyze-crud-operations

  3. In the navigation bar, click on “Create a CRUD matrix”

    generate a crud matrix in visual expert

  4. A message confirms that the operation was successfully completed.
    Click “Open” to access the CRUD matrix.

    generate-a-crud-matrix-to-analyze-crud-operations(4)

  5. Excel should prompt a warning about the file format.
    This is because VE exports the data in HTML format and open it as an excel file.
    Click “Yes” to ignore this warning:

    generate-a-crud-matrix-to-analyze-crud-operations(5)

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

    generate-a-crud-matrix-to-analyze-crud-operations(6)

Watch a Video

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