Archives of the TeradataForum

Message Posted: Tue, 08 Nov 2005 @ 21:36:54 GMT

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

SQL Assistant gets its information from the ODBC driver. I dont know if Microstrategy uses ODBC or CLI but if it uses ODBC it should have no problem getting this info.

ODBC itself may use either of the following methods:

     Help column .*

or

     Select from dbc.columns

If it uses select from Columns it would have to be recursive (or a self join) since as you say the data is not stored for views so you have to identify the underlying table columns and then get the data from there.

Mike Dempsey
Teradata Client Tools

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