![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Wed, 22 Jul 2009 @ 08:49:52 GMT
Subj: | | Re: Tracking changes to table |
|
From: | | Dieter Noeth |
Chaim Sender wrote:
| Can anyone tell me how I would be able to see the history of changes to a table - ie: if indexes were added, columns dropped etc
etc. | |
| I know that in dbc.tables one can see the last user to alter the table - but I want to be able to see a history - not just the last
change. | |
Better than DBQL is the Access Log, because it will never miss any change:
BEGIN LOGGING WITH TEXT ON EACH TABLE, INDEX;
The basic rule is: DBQL is for performance info, Access Log for security info
Dieter
| |