Archives of the TeradataForum
Message Posted: Fri, 05 Aug 2016 @ 09:20:21 GMT
Subj: | | Getting a list of tables and views within a views |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Thursday, August 04, 2016 01:31 -->
I've written a program to parse through a View DDL and list out all the tables and views within in, in addition it will also list out the size
of the tables and stats on them, this is meant for Windows only and you need to have bteq installed. Get it here:
github.com/...
The program is db_child.exe and has been written in Python, however you do not require python installed to run it, you do however need bteq,
currently only for Windows Machines.
Take a look at the README.md for more info
|