Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 18 Feb 2005 @ 15:36:18 GMT

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

Subj:   Re: Views referring tables
From:   Diehl, Robert


I have not read the whole thread so someone may have suggested this approach. Just run a show select * against the view.

     show select * from databasename.viewname;

Replace databasename and viewname with appropriate values.

A show select gives you the ddl for all objects and child objects needed to resolve the query. The resultant set is not that easy to use, but it will show all objects needed.


Bob Diehl

  <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