Get the list all Database object which are created or modified from last 15 days

We are creating a dashboard where we are monitoring the database object modification (alter). With the help of below script, we will get the list of all altered object.

Object alter

SELECT o.type_desc,o.type,o.name,o.create_date, o.modify_date,DATEDIFF(D,o.modify_date, GETDATE()) as Dayes FROM sys.objects o inner join sys.all_objects m on o.object_id=m.object_id WHERE o.type in ('C','D','F','FN','P','PK','SN','TF','TR','TT','U','UQ','V') and DATEDIFF(D,o.modify_date, GETDATE()) < 15

  

Object created

SELECT o.type_desc,o.type,o.name,o.create_date,o.modify_date, DATEDIFF(D,o.create_date, GETDATE()) as Dayes FROM sys.objects o inner join sys.all_objects m on o.object_id=m.object_id WHERE o.type in ('C','D','F','FN','P','PK','SN','TF','TR','TT','U','UQ','V') and DATEDIFF(D,o.create_date, GETDATE()) < 15

   

We will get the type description on below link.

Get the list all tables in a SQL server database:

https://bageshkumarbagi-msbi.blogspot.com/2016/06/get-list-all-tables-in-sql-server.html