Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the date and time of last updated table?
- 3 Answers
- 9113 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 ? | 8 Yes | 3 No |
Post New Answer View All Answers
Are semicolons required at the end of sql statements in sql server 2005?
Why do we backup Active Directory ?
What is tabulation?
Where sql server user names and passwords are stored in sql server? : sql server database administration
How to check parameter value in stored procedure sql server?
How self join is different from outer join?
How do you Implement SSIS Packages in your Project?
How to declare a cursor with "declare ... Cursor" in ms sql server?
List the different types of collation sensitivities in sql server?
Can a table have 2 foreign keys?
what is a sub-report?
What is a document index?
How to use linked server?
Mention the differences between substr and charindex in sql server.
How is sql used in sql server?
