Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the date and time of last updated table?
- 3 Answers
- 9449 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
What is meant by Active-Passive and Active-Active clustering setup?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
In what sequence sql statement is processed?
How to update values in a table with update statements in ms sql server?
What is report subscription?
When cursors are useful?
When is the use of update_statistics command?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What is 2nf normalization?
How to create a new table in a given schema?
Create and insert into temp table in sql server?
Explain sub-query?
Do you know how to send email from database?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
What is the New in SQL server 2008?
