Archives of the TeradataForum
Message Posted: Fri, 18 Feb 2005 @ 11:42:57 GMT
Martin Pirklbauer wrote:
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 :-)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|