Monday, 2 May 2016

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'

(this query will list out all table which have been modified(make changes) within last 5 days)

Visit Our New Site for HR Interview Questions Answers
Sponsored Ads

1 comment: