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

• 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

for PowerBuilder     for Oracle      for SQL Server 

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:
   
   




3. In the navigation bar, click on “Create a CRUD matrix”
   
   
   
   
4. A message confirms that the operation was successfully completed.
   Click “Open” to access the CRUD matrix.
   
   
   
   
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:
   
   
   
   
6. The CRUD matrix opens in Excel. You can edit, share, print it as you like.