Sample Header Ad - 728x90

Are default values for a column still required if using audit triggers?

0 votes
1 answer
114 views
I have a couple of audit columns in my table: - modified_by - modified_date I have an AFTER trigger set up to automatically update these columns whenever data is inserted or modified, with current_user and current_timestamp respectively. Would there be any benefit in also adding these as default column values (I assume not given that inserts are already handled by the trigger)?
Asked by greenandblue (3 rep)
Feb 27, 2024, 10:30 AM
Last activity: Feb 27, 2024, 11:00 AM