Cross-References Homepage

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

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

Why Generate a CRUD Matrix?

  • 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 have several options to create a CRUD matrix:
    1. Select Tables, Columns or Table synonyms to show which objects are using them.
      Create CRUD Matrix
    2. Select objects (functions, procedures, etc.) to show which tables they are using:
      Select functions or procedures for CRUD Matrix
    3. Select views to show which tables they are using:
      The CRUD Matrix will also show which objects are using the selected views.
      In the matrix, Views may appear with both callers (lines) and callees (columns).
      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

In this example, Views were selected before generating the CRUD matrix.
They are listed as both callers and callees:

CRUD Matrix Showing Callers and Callees

 

Video Tutorial for Generating CRUD Matrix

 

See Also

PowerBuilder, Oracle, SQL Server, Code Exploration, Cross References