sorry for digging up the old topic..
can somebody please let me know from where is the old view definition (database and columns) is fetched when I execute
SHOW QUALIFIED SEL * FROM VIEW ??
In dbc.tables and dbc.tvm, I can only see the statement used to create the view like 'replace view as lock row for access sel * from table', but when i use qualified I can see all the columns that were there when the view was created..
I'm just curious where the old information is still available..
when QUALIFIED is used (in this case) ,Teradata replace * with fully qualified actual column names of base table. As a result you are viewing the column names in view definition .