Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the date and time of last updated table?
- 3 Answers
- 17711 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
How much space does sql server 2016 take?
What is the difference between composite index and covering index?
How to move database physical files in ms sql server?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
When to use null data driven subscription?
what is a schema in sql server 2005? : Sql server database administration
How can we determine what objects a user-defined function depends upon?
What is the difference between drop table and truncate table?
What are the dmvs? : sql server database administration
Tell me what is the difference between locking and multi-versioning?
What are sql server functions?
What do you mean by authentication modes in sql server?
what kind of lan types do you know? : Sql server database administration
why would you use sql agent? : Sql server database administration
How many cores do I need for sql server 2016?
