Display Added and Modified Dates of Columns in a Table in SQL Server

Hello to everyone,

In this article, I will give information about displaying the date of addition and modification of columns in the table in SQL Server.

In SQL Server, in some cases, you may want to display the date of insertion and modification of columns in a table.

You can easily do this using the code below.

SELECT obj.name,
       col.name,
       obj.create_date,
       obj.modify_date
FROM sys.objects obj
    INNER JOIN sys.columns col
        ON obj.object_id = col.object_id
ORDER BY obj.modify_date DESC;

When you run the above code, you will see a result similar to the one below.

As you can see, we have displayed the addition and modification dates of the columns in the table.

Good luck to everyone in business and life.