All Forums Database
webtduser 5 posts Joined 11/13
11 Jan 2014
Way to retrieve old definition of a view

HI,
 
Other than from the backup, Is there a way to retrieve the old definition of a view.. like any dbc tables?
 
Thanks!!!

Raja_KT 1246 posts Joined 07/09
12 Jan 2014

AFAIK, if dbc and backup are not possible, then I can think of Unity Director, if you have system1 and System2. Just my thought.
Cheers,

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

webtduser 5 posts Joined 11/13
12 Jan 2014

Thanks!! Can you please point me to a dbc table which can give that?

Raja_KT 1246 posts Joined 07/09
12 Jan 2014

Will this help you?

example

select requesttext,tablekind from dbc.tables where databasename='dbc' and tablekind='V'

 

and you can verify with.

SHOW QUALIFIED SELECT * FROM VIEW1 say

 

Also if you are looking for some old definitions, then all organizations maintain repository of versions.

 

Cheers,

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

webtduser 5 posts Joined 11/13
12 Jan 2014

Thanks Raja!!
but i know that we can get the latest(current) view definition from dbc.tables.
I was wondering if there is any other table which can give old view definition..
Unfortunately, we do not maitain the version of views.. We do have backups..I was trying to find out if there is any other way !!
 
Thanks for your replies !!!

Raja_KT 1246 posts Joined 07/09
12 Jan 2014

Did you check DBQL tables, if you enable them like Querytext from DBC.DBQLogTbl?

BEGIN/REPLACE QUERY LOGGING:

Also  I can think of Teradata MDS. I think like other repositories , it should have this.

 

Cheers,

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.