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