Check Recently Modified Objects In SQL Server Database

Here is a SQL query to get recently modified objects in a SQL Server database.

A database is a collection of objects such as tables, views, procedures, triggers, and so on. Sometimes we need to know the recently modified objects in a SQL Server database. We can use sys.objects for this purpose.

Run the below query. It will list objects in recently modified order.

SELECT name, create_date, modify_date
FROM sys.objects order by 3 desc

This will list all columns of all recently modified objects.

SELECT * FROM sys.objects order by modify_date desc