Archives of the TeradataForum
Message Posted: Thu, 18 Jun 2009 @ 09:33:16 GMT
I need to be able to load the CREATE statement for each table into another table with some manipulation of the values - i tried using dbc.tables.requestText but this appears to be last the DDL run on the table.
Basically I want to be able to load the results of SHOW TABLE for a list of tables into a varchar field in another table.
I tried macros + procedures with no success.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|