Archives of the TeradataForum

Message Posted: Thu, 05 Jul 2012 @ 10:04:47 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

Enable the accesslogging on the tables.

Sql:

     Select tablename from dbc.tables  where databasename='abcd'
     Minus
     Select TVMName from dbc.accesslog where DatabaseName='abcd'

Thanks,

Mahesh

	<Prev	Next>		<<First	<Prev	Next>	Last>>