trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Carol Pearson <>
Subject Re: is there docs about systables of trafodion?
Date Wed, 03 Jan 2018 06:54:50 GMT
A year or two ago, I did just that and then used the free version of an
on-line tool to build an ER diagram of the tables at that time. I wanted to
write a bunch of different metadata queries for some research I was doing,
and I found a chart was helpful.

I will poke around to see if I can find the details on my starting point,
and on the tool I used.  I know it wasn't Visio because I didn't have a
license for it at the time, but I don't recall what it was... Either way,
the version I had at the time is a bit out of date now.

In any case, it started out just as Dave described:

 1)  showddl on each metadata table, and also the tables that support
statistics/histograms stored in each schema
 2)  Massage the output with emacs (ok, you could use sed/awk or whatever
other tools you want) to get into a .csv format
 3)  Import .csv fileI into a tool to build a table structure for each
 4)  Format to add the additional info, to display relationships, group
related tables, etc.

-Carol P.

Twitter:  @CarolP222

On Tue, Jan 2, 2018 at 9:34 AM, Dave Birdsall <>

> I don't think there is any documentation of the metadata tables at the
> moment. At least I don't see any in the manuals.
> If you simply want to know what columns exist in each table, you can do
> the following:
> Set schema "_MD_";
> Get tables;
> Then for each table, do "showddl <table-name>".
> Some of it is self-explanatory.
> If you would like to see documentation in the manuals, please feel free to
> write a JIRA requesting that. (Or I can do it for you if you wish.)
> Thanks,
> Dave
> -----Original Message-----
> From: []
> Sent: Friday, December 22, 2017 12:28 AM
> To: dev <>
> Subject: is there docs about systables of trafodion?
> Hi all,
>     i want to get the information about the systables of trafodion in
> schema _MD_, include column values and its descriptions, is there docs
> about that?
> 李英帅
> 易鲸捷信息技术有限公司
> 手机:18701691214
> 邮箱

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message