Analyze CRUD operations with a CRUD Matrix (Create, Read, Update, Delete)

Build a CRUD Diagram and see which objects or programs Create/Read/Update/Delete which Tables.

  • 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...

List the components accessing tables or columns

Try Visual Expert Now

How to generate it:

  • Select one or several tables with the [Ctrl] key
  • Execute the CRUD Matrix feature in the navigation bar.
  • The same goes with DB columns.

Export crud matrix

Open crud matrix in Excel

Open crud matrix in Excel

See a Video

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