Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Wed, 03 Aug 2005 @ 10:55:29 GMT





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




Subj:   Re: Correlating Multiple Views and Join Views to Base Tables
 
From:   Coffing Christopher L



Andrew Wrote

  "This may be of some use, courtesy of a colleague."  


          "show sel * from databasename.viewname"

If you want the fully qualified results you can use the following SQL.

     show Qualified sel * from databasename.viewname

Chris Coffing
Air Force Knowledge Services (AFKS)
Lead Operations & Support
Lead Teradata DBA
Teradata NCR Contractor
Teradata Certified Master





     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008