Archives of the TeradataForum
Message Posted: Fri, 18 Feb 2005 @ 11:42:57 GMT
| 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 :-)
Dieter
| 
