Archives of the TeradataForum

Message Posted: Wed, 03 Feb 2010 @ 10:08:46 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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?

Steve

	<Prev	Next>		<<First	<Prev	Next>	Last>>