Access details about a table / column

Database

Access details about a table / column

Hi Folks,

How can I find out when a table/column was accessed and why whom in teradata ? Access would mean any DML/DDL statements using the column.

Any help is appreciated.

Thanks
Tags (1)
2 REPLIES

Re: Access details about a table / column

Hi raj_2008,
you can use the following SQL query:

SELECT
TableName
FROM
DBC.TABLESV
WHERE
RequestText LIKE '%columnName%'

Re: Access details about a table / column

I guess you might be looking for DBQL. you would get exhaustive info from DBQL provided it is available in your installation and your id has requisite access.
Sel * from dbc.dbqlogtbl