How to find the date and time of last updated table?
- 3 Answers
- 16563 Views
- I also Faced
- E-Mail Answers
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
What is the difference between for xml raw and for xml auto?
how many bits ip address consist of? : Sql server database administration
Do you know what is fill factor and pad index?
Why use identity in sql server?
Differentiate between ms sql server reporting services vs crystal reports?
How to create a Master database in SQL server ?
Explain unique key in sql server?
How to verify the port number of the sql server?
What are the built in functions in sql server?
Define Wed Edition in SQL Azure?
What is an indice?
Is candidate a key?
What is the difference between dataadapter and datareader?
How do I clean up sql server transaction log?
Explain sql server service broker?
