Audit Tables
anjana83Apr 12 2010 — edited Apr 12 2010While creating audit table, how do I decide the columns.I need to have columns for old and new values. If the primary key is a composite key of 2 columns, do I need to have old and new values of both these in the audit table? and how do I decide the primary key for the audit table?
Thanks..