Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the date and time of last updated table?
- 3 Answers
- 17456 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
application server is slow what may be the problem
What structure can you implement for the database to speed up table reads?
What is the use of keyword with encryption.
Do you know data definition language, data control language and data manipulation language?
What is the use of partition by in sql server?
Differentiate between sql temp table vs table variable?
what are the important architecture components of SSRS?
What is scalar user-defined function?
What is TDS(Tabular Data Stream) Gateway?
What are the new data types are introduced in sql 2000?
How many categories of data types used by sql server?
What is indexed view?
What is a covered index?
What are cursors in ms sql server?
What is precedence constraint?
