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


In 4.1 we added a new flavor of this


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