|
|
Archives of the TeradataForum
Message Posted: Tue, 04 Apr 2006 @ 10:16:55 GMT
Subj: | | Re: Is Table being used by Stored Procedure or Macro |
|
From: | | Cappelli, Andrea |
Well, I think that all you need is, if you have the possibility to use Teradata Administrator , right click on the table and then left click on
References.
The query on the data dictionary will be something like:
SELECT DatabaseName,TVMName,TableKind AS "Type"
FROM dbc.TVM T
,dbc.dbase D
WHERE D.DatabaseId=T.DatabaseId
AND CreateText LIKE '%"Database_Name"."Table_Name"%' (NOT CS) ORDER BY 1,2;
Hope this helps...
Andrea Cappelli
NCR Italia
Teradata Professional Services
Teradata Certified Implementation Specialist V2R5
| |