Tags for dictionary
CompressValueList add blank spaces in DBC.Columns field
Hi all, I'm writing here because I didn't find any previous entry that solve my strange problem. 1) I define a table that has a column with COMPRESS clause
columns dbc dictionary compress compressvaluelist create sql
Get DDL from DBC tables
Hi everyone, I'm tryng to build a set of queries with the objective of getting the DDL of tables only from the info inside the dbc tables (columns, tvm, dbase, tableconstraints...). I started from the table dbc.columns to get all the info about every field of a table. Below you can find the work in progress query.
ddl dictionary dbc format columns
Stored procedure and its dependency using Data Dictionary tables
  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.
stored procedures procedures data dictionary administration dictionary dependency
Object dependency
Hi,   How to get "View vs Table dependency" from dictionary tables by simple querying them? Query needs to list the table names  used by a View. It is possible in Oracle using dba_dependencies and similar table to get the list of tables used by a view. Please advice. Karteek
teradata sql dictionary