How to find the date and time of last updated table?
- 3 Answers
- 16805 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 are various aggregate functions that are available?
What is the difference between varchar and varchar(max) datatypes?
List out what other servers you can use with ssrs?
Explain what is lock escalation?
Why do you want to join software field as you have done your BE in Electronics?
Can we insert data into a view?
Does the unique constraint create an index?
What is 3nf normalization?
What is reportserver and reportservertempdb ?
How much is a sql server license?
What is the server name in sql server?
How do we synchronize On-Premise SQL server with SQL Azure?
What is user-defined scalar function?
Other than truncate statement, which other command can by-pass the trigger on the tables?
What are date and time data types in ms sql server?
