How to get the list of tables changed with in the database in last 5 days? Write SQL Query, Interview Question
SELECT name , create_date , modify_date FROM sys . objects WHERE modify_date >= GETDATE ()- 5 and type = 'U' (t...

https://www.interviewquestionspdf.com/2016/05/how-to-get-list-of-tables-changed-with.html
SELECT name, create_date, modify_date
FROM sys.objects WHERE modify_date >=
GETDATE()-5 and type ='U'
(this query will list out all table which have been modified(make changes) within last 5 days)
good
ReplyDelete