 |
 |
Archives of the TeradataForum
Message Posted: Wed, 29 Nov 2001 @ 03:36:17 GMT
| Subj: | | Source for DDL in SHOW TABLE |
| |
| From: | | Scott Summers |
Can anyone help understand how SHOW TABLE works (i.e. how is the displayed DDL derived)? It cannot be from dbc.tables.requesttext, which
would be the obvious answer, because the requesttext column only holds the last DDL statment for the table. We have many tabLes with an
ALTER TABLE statement rather than the CREATE TABLE statement in the requesttext column. Looking in dbc.tvm I don't see anything with the
actual table DDL, and I am not sure where else to look. I thought maybe the createtext column in dbc.tvm, but that was not it. Maybe the
SHOW TABLE results are dynamically generated from the dbc tables? If so I can imagine how I would try to replicate that process but I think
it would get pretty messy. I know I could also write a script that generates the SHOW TABLE statements, executes them, and saves the DDL to
a file, but that's not what my user wants.
Any help would be greatly appreciated.
Thanks,
Scott
| |
