I have a database consisting of several tables and in a separate table, I would like to store every column within every table and the last time the data in the columns was modified (i.e. following an UPDATE, INSERT or DELETE) statement.
If I only update one column in a table, the record for that column in my log would then update with the last modified timestamp.
Is this possible and is there a suggested approach for it? My initial thought was potentially to use a database-level trigger but wasn't sure if this could be setup to monitor changes to all columns in all tables. I don't want to have to create an individual trigger on each table but wasn't sure how else I could monitor changes at a column level.