How can we check who has last modified the table ? Means who has alter a particular table?

Soumya_Behera · November 2013

Daniel_Leybovic · November 2013

QUERY_REQUESTS

Returns information about user-issued query requests.

Something like this:

SELECT USER_NAME,

       TRANSACTION_ID,

       STATEMENT_ID,

       MAX(START_TIMESTAMP)

  FROM QUERY_REQUESTS

 WHERE REQUEST ILIKE '%ALTER%TABLE%table_name%';

Soumya_Behera · November 2013

Thank you so much Daniel . Your reply really helped me.

We're Moving!