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.