You must Sign In to post a response.

03 Jan 2017 11:47

Points:	2

How to get list of table that has no insert/update in last one year

Hi Friends,

How can i get list of tables in database which has no insert/Update in last one year.

Thanks in advance.

Regards,
Aaditya Chaubey

#768635

03 Jan 2017 13:09

Points:	3

Hi,

you can use simple query and get the list of details.



Select name, id, crdate
From sysobjects
Where type ='U'
and DateDiff(D,refdate,getdate()) < 365;

We can use the above query for getting the list of tables and also if you want Procedure we can use 'P' in the query.

Thanks,
Mani