Check Recently Modified Objects in SQL Database

Check recently Modified objects (tables,Stored Procedures,Functions ,triggers etc.) in SQL Database.

Run the below query, it will show objects in recently modified order.

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

For full detail, you can use below query,

SELECT * FROM sys.objects order by modify_date desc