How to find the date and time of last updated table?
Answer Posted / payal nath
We can determine the last time a user table was altered
using the below query.
SELECT name, create_date, modify_date
FROM sys.tables
ORDER BY modify_date DESC
The modify_date column is updated whenever a column is
added or altered for the table.
It is also updated if the clustered index is changed.
Is This Answer Correct ? | 21 Yes | 15 No |
Post New Answer View All Answers
How to name query output columns in ms sql server?
Explain where clause?
What is meant by dirty read?
Why are views required in the sql server or in any other database?
Can you explain what is indexed view? How to create it?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
How to add code to the existing article (using improve article)?
What is analysis service repository?
Write a SQL queries on Self Join and Inner Join.
What is bcnf normalization form?
What is report server project?
What are the purpose of Normalisation?
Explain a checkpoint?
What is measure group, measure? : sql server analysis services, ssas
What is blocking?