Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 06 May 2003 @ 15:50:06 GMT


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


Subj:   Re: List of objects used by views
 
From:   Dennis Calkins

Hi,

In 4.1 we added a new flavor of this

SHOW QUALIFIED .....

and it will make sure the Database names are added to the results just in case you need to know which databases the tables are in. Some people have the same table name in multiple databases so having the results FULLY QUALIFIED is a must.

SHOW can be used against any SQL.



     
  <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: 27 Dec 2016