Archives of the TeradataForum
Message Posted: Wed, 03 Feb 2010 @ 10:08:46 GMT
We are planning on moving a subset of our users/applications from one Teradata instance to another. I know what tables will be moved and need to identify what users will be effected. (Note - We have a 3rd party tool that logs/parses the users SQL. We have nested views and multi table/database joins within some views.)
I need to create a cross reference between tables and views so I can understand the user to table relationship. My current plan is to identify all views (from DBC.TABLES) and then issue a SHOW SEL * FROM view; and capture the resulting DDL, and extract the objects referenced in the CREATE TABLE, CREATE VIEW, or REPLACE VIEW statements.
I assume Teradata MDS provides such functionality, but not particularly interested in installing it.
Any additional suggestions?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|