Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 02 Feb 2007 @ 11:24:38 GMT

  <Prev Next>  
Next> Last>>  

Subj:   How to dump all object definitions in a database
From:   kaare.wehn


I need a query that returns all object definition in a database (tables, view, macros, procedures). I have solved this by creating an external application that executes SHOW TABLE/VIEW/MACRO/PROCEDURE on all the objects. It works, but it takes a long time.

I have also checked out TVM.CreateText and this field would be a great way to dump a database, but it's not complete:

1. Only views and macros have a complete definition in CreateText.

2. Tables have NULL in CreateText.

3. Procedure definitions are stored in a non-readable format.

The information I'm requesting is certainly present in the database (SHOW TABLE etc.) but it's not accessible from a query. Or is it? If there's a secret feature somewhere, please let me know.

Thank you for a great web site!

Kaare Wehn

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020