Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 18 Feb 2005 @ 11:42:57 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: TDAministrator: References does not list all views
From:   Dieter Noeth

Martin Pirklbauer wrote:

  If you go to a table with right click you can choose 'References' and expect to get all views lying underneath. Actually that's not the case. If the view is quite long, it will not be shown.  

  The reason why is quite simple:  

  Long views are not stored in DBC.TVM or DBC.dbase but in DBC.TextTbl. The Administrators Reference does not select this table.  

This is hard to implement as a query, because there may be several rows per DDL and line 1 may end with '"mydatabase"."myt' whereas line 2 starts with 'able" ;-)

And even if it was possible, referencing SPs would still be missed, because there's no DDL at all stored for a SP.

And the result may be wrong if there's a table with a tablename.columname similar to a databasename.tablename, e.g. create table "dbc".tvm(...

There've been several treads on it on the forum.

If you want exact information use Meta Data Services :-)


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016