Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the date and time of last updated table?
- 3 Answers
- 9261 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
How to view the error log for any specific instance? : sql server database administration
What are the 3 types of schema?
Which data type columns are the best candidates for full-text indexing?
What are Row versions of DataRow?
How to change the system date and time from SQL Plus Terminal ?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is difference between rownum and row_number?
What are the filtered indexes?
Do you know what are the restrictions that views have to follow?
Explain about analysis services?
How to get the definition of a stored procedure back?
What is the temp table?
How to add a new dsn with the odbc driver for sql server?
If a table does not have a unique index, can a cursor be opened on it?
what is bit datatype? : Sql server database administration
