Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Finding data types in views
From:   Dempsey, Mike

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 ?.?.*



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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023