Archives of the TeradataForum
Message Posted: Wed, 29 Nov 2001 @ 03:36:17 GMT
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.
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023