Archives of the TeradataForum

Message Posted: Fri, 17 Oct 2003 @ 23:13:52 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Sure. Try:

SELECT
        DatabaseName,
        TVMName,
        TableKind AS "Type"
FROM dbc.TVM T,dbc.dbase D
WHERE
        D.DatabaseId=T.DatabaseId
        AND CreateText LIKE '%"DB_Name"."Table_Name"%'
ORDER BY 1,2;

Where you replace just DB_Name with your database name and just Table_Name with your table name. Very important, do keep the double quotes!

--Jason

	<Prev	Next>		<<First	<Prev	Next>	Last>>