Tables metada browser

[Blog bot]

Источник: http://alexvoy.blogspot.com/2024/12/...a-browser.html
==============

Following my previous article I add a simle form to browse tables metada, like, fields, relations, their attributes, etc.

It has the old good horizontal and vertical splitters to facilitate your browsing.

Filtering by attributes like System or Data entity lets rapidly find required subset of tables and fields.

Do not forget that each grid can be exported to Excel.

All data are saved in three InMemory temporary tables, and all the logic is implemented in one class wzhTableTools.

So, you can easily elaborate this solution if some other metada need to be exposed.

Challenge: I still cannot find how to get OnDelete action type for a relation. :(




Class



<div style="background: rgb(255, 255, 255); border-color: gray; border-image: initial; border-style: solid; border-width: 0.1em 0.1em 0.1em 0.8em; border: solid gray; overflow: auto; padding: 0.2em 0.6em; width: auto;">internal final class wzhTableTools{ public static wzhTablesTmp populateTables() { Dictionary dict = new Dictionary(); int numOfTables = dict.tableCnt(); DictTable dictTable; TableId tableId; int j; wzhTablesTmp wzhTablesTmp; // Loop through all tables in the system for (j=1 ; j