sql-server | style-guide

Style Guide - SQL Server Auditing Column Names

Naming convention for auditing fields in a SQL server table.

Abhith Rajan
Abhith RajanFebruary 05, 2020 · 1 min read · Last Updated:

For most of the tables in our DB will have some kind of auditing fields. Following are the column names I used to use for those auditing fields.

Creation Audited

Column NameTypeNullableDescription
CreationTimedatetime2(7)NOT NULLeg. 2019-09-15 13:56:13.8955178

Modification Audited

Column NameTypeNullable

Soft Delete

Column NameTypeNullable
IsDeletedbitNOT NULL

If you have worked with ABP before, you know from where I adopted the naming convention.

When I work on a non-ABP project, I used to follow the same column names.

Let me know what you used to name for auditing columns in the comments. 👇

Additional Resources

This page is open source. Noticed a typo? Or something unclear?
Improve this page on GitHub

Abhith Rajan

Written byAbhith Rajan
Abhith Rajan is a software engineer by day and a full-stack developer by night. He's coding for almost a decade now. He codes 🧑‍💻, write ✍️, learn 📖 and advocate 👍.

Is this page helpful?

Related SnippetsView All

Related ArticlesView All

Related VideosView All

Using SQL Data Sync for Bidirectional Data Replication in SQL Server & Azure SQL DBs | Data Exposed

Build fast, scalable data system on Azure SQL Database Hyperscale | Clearent

SQL Server 2017 Graph Database

Related Tools & ServicesView All


sequel fumpt

sqlfmt is an online SQL formatter. It is pronounced sequel fumpt. Its purpose is to beautifully format SQL statements.

SmarterASP.net - Unlimited ASP.NET Web Hosting

ASP.NET Hosting by SmarterASP.net. Unlimited ASP.NET Hosting Plans Starting at $2.95 a month.