Archives of the TeradataForum

Message Posted: Thu, 08 Apr 2010 @ 15:25:51 GMT

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

Unfortunately this is correct.

When you expand the Views node in SQL Assistant it calls an ODBC (or TD.Net) function that issues these HELP commands under the covers.

You can use the Import function in SQL Assistant to execute all the Help commands. Just Export a list of the view names that you want to retrieve then point to that export file as the Import file for your import.

The Query would be

     HELP COLUMNS ?.?.*

Or

     HELP COLUMNS ?.*

Depending on whether you export both Databasename and Viewname, or just Viewname. (and assume current database)

If you have a large number of views in your database it can take a long time to issue a Help command for each view. That is why in the (soon to be released) SQL Assistant 13.10 there is a new 'fastpath' option that will return only the column names for views when you use another new option that loads the column information for all tables/views in a database at one time.

Mike Dempsey
Teradata Client Tools

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