I have this query to find out created table in last N days.

Select name, id, crdate

From sysobjects

Where type ='U'

and DateDiff(D,refdate,getdate()) < 7;

But it will get last created, I want last modified or insert/updated table.

Is there any idea?