Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the date and time of last updated table?
- 3 Answers
- 17566 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
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
Explain insert into select statement?
What are distributed partitioned views?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What is blocking?
What is order of B+tree?
Which are the new data types introduced in sql server 2008?
what are triggers? : Sql server database administration
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
Explain DBCC?
How does clustered and non clustered index work?
What are the differences between lost updates and uncommitted dependencies?
What do you understand by user-defined function in the sql server?
What is RAID? What are the different types of RAID configurations?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
