How to get list of table that has no insert/update in last one yearHi Friends,
How can i get list of tables in database which has no insert/Update in last one year.
Thanks in advance.
Select name, id, crdate
Where type ='U'
and DateDiff(D,refdate,getdate()) < 365;