Hi,
 
is there any information provided by the data dictionary which allows one to differentiate between the 3 types of foreign keys supported by Teradata?
 
(1) Row level
(2) 'With check option'
(3) 'With no check option'
Thanks,
 
Andrew.

I am looking for a way to quickly retrieve all macro, view and stored procedure text. People on this thread have already recommended using the show procedure/view/marcro commands, but that would require calling everything sequentially.

Hi,

Does Teradata make use of "Query Caching" for the fast retrieval of tactical query results? If so, which tables in the data dictionary are used for this purpose? What are the pros and cons of making use of this concept in data warehouse?

Hi All

I would like to find out the dependency between Stored procedures and the associated tables using data dictionary tables. I have tried my best to find out but went in vain.

Please suggest me a way to find out using teradata only.

I have the following SQL to create a view

REPLACE VIEW PRSN_GLOBAL_V.LSS_PRD_RSN
AS LOCKING ROW FOR ACCESS
SELECT
srv_rsp_evt_id (INTEGER, NAMED srv_rsp_evt_id, Title 'Survey Response Event ID')
, srv_rsp_txt (VARCHAR(1000),NAMED mn_rsn_not_prd_txt , TITLE 'Main Reason Not Productive' )
FROM EVENT_V.SRV_RSP
where srv_qst_cde in ('8303','8307')

Hi all,

I am the author of a documentation tool for all major DBMS on the market, and I recently added support for Teradata. I have tried it on the sample dbs that Teradata 13 ships with, as well as the system catalog itself (DBC). What I'd really like though are some beta testers to run it against some real world databases.

The tool is called SqlSpec. You give it a connection string to your database, and it generates comprehensive documentation for your db, with PK/FK graphs, dependency graphs, and lots more.