Post reply

Should audit columns exist in each table?

  • September 26, 2017 at 6:08 am

    #323751

    Hello All,

    I am creating database schema for an application from scratch. I have an idea to use four standard columns CreationDT, CreatedBy, ModifiedDT, ModifiedBy in each table I am creating  just for audit purpose. But, one the another edge I am thinking that is it really good idea to do for every table. Can anybody please share your ideas?

    Regards
    VG

  • September 26, 2017 at 6:27 am

    #1960935

    Depends.
    What do you need them for, and what are your audit needs?

    If you don't care about changes to rows, don't use them.
    If you need to know what changed, then they're not adequate.
    If you just need to know when a row changed, then use a modified date.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 27, 2017 at 7:30 am

    #1961134

    Thanks

    Regards
    VG

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply