How to get recently created & modified DB Objects

Reading Time: 1 minute

If you are software tester or a software developer and if you want to know which objects are recently created or modified then here is the query

You can add filters/where conditions if you want specifics example you can include date ranges, etc…

SELECT [name],
       create_date,
       modify_date
FROM sys.all_objects
ORDER BY create_date DESC,
         modify_date DESC;

If you are looking only for SQL Tables then the below query would be enough

SELECT [name],
       create_date,
       modify_date
FROM sys.tables
ORDER BY create_date DESC,
         modify_date DESC;