Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
tracking object changes in Vertica
Is there a way to find out who made the latest modification to an object such as a table or view in release 7.1?
Thanks
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Comments
There are two types of objects whose last modified time is recorded.
In the system table PROJECTION_DELETE_CONCERNS:
Lists projections whose design may cause performance issues when deleting data. This table is generated by calling the EVALUATE_DELETE_PERFORMANCE function.
In the system table COMMENTS, which contains information about comments associated with objects in the database.
Hope that helps,
Sarah
Although the retention may be limited, you may want to try looking in query_requests: