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;