SQL Script to check what was changed in database after specific hour Last night

SELECT name, 

 TYPE, 

 type_desc, 

 create_date, 

 modify_date 

FROM sys.objects 

WHERE TYPE IN ('U','V','PK','F','D','P') 

AND modify_date >= Dateadd(HOUR,21,Cast((Cast(Getdate() - 1 AS VARCHAR(12))) AS SMALLDATETIME)) 

ORDER BY modify_date 

--U - Table

--V - View

--PK - Primary Key

--F - Foreign Key

--D - Default Constraint

--P - Procedure