Archives of the TeradataForum

Message Posted: Tue, 14 Dec 2004 @ 11:12:22 GMT

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

The info about the columns that make up the view can be retrieved either using

- help column <viewname>.<columnname> {to get details of the column provided you knew the column names or use "help view <viewname>" to retrieve your columns, but this may not provide you the column details}

- OR query the tvfields table joining between tvm and tvfields to retrieve all columns that form your view.

But the link that you are asking - reference between the basetable and the view may not be possible - because I think such a relation is not maintained in the dictionary except for the createtext or the requesttext in tvm which is nothing but the DDL associated with the view. I think it is these texts that get used during view resolution and thereby avoiding the kind of relation, that you are looking for.

The way out I think should be Metadata Service.

Narayan

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