Archives of the TeradataForum

Message Posted: Thu, 08 Apr 2010 @ 14:29:26 GMT

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

You can do a HELP_COLUMNS ..*; and get all the physical attributes of any view. However, this only does it for one view at a time. I created a BTEQ process that would go through a DB (one or more) that contained views and end up putting all the detail view column characteristics into a table for users/developers, etc. to reference. There is no easy way (never has been for TD) to get the column characteristics from the DD/DC with SQL like, say Oracle ! BI tools generally use the HELP COLUMN command to retrieve those and I would think that SQL Assistant does also.

JK Wight

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