0

How to get recently created & modified DB Objects

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…

Microsoft SQL

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;

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.