Источник:
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