Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the date and time of last updated table?
- 3 Answers
- 9309 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 will you monitor replication latency in transactional replication? : sql server replication
What is ddl command?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
How dts is used to extract, transform and consolidate data?
What is the difference between for auto and for nested?
What is postgresql server?
What is ssrs?
How do you delete duplicate rows in sql server?
How to remove duplicate rows from table?
What are the advantages of log shipping?
Explain about the command-line tool SQLCMD?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
Why is normalisation important?
What are transactions in sql?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
