Answer / 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.

Answer / manoj

select table_name from user_tables where last_analyzed in
(select max(last_analyzed) from user_tables)

Answer / manoj

select table_name, to_char(last_analyzed, 'DD-MM-YY
HH:MI:SS') from user_tables where last_analyzed in (select
max(last_analyzed) from user_tables)

What is database white box testing?

0 Answers  

---

What are functions

3 Answers  

---

What is the diff between Dynamic queries and static queries

1 Answers   CGG, ICS Integrated Computer Solutions,

---

what are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

---

How can you get @@error and @@rowcount at the same time?

9 Answers  

---

What is the difference between inner join and equi join?

0 Answers  

---

How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?

2 Answers   IBM,

---

How to create a simple user defined function in ms sql server?

0 Answers  

---

Name 3 ways to get an accurate count of the number of records in a table?

0 Answers  

---

What is not null constraint?

0 Answers  

---

how to overcome kernel isssues

0 Answers   Fortune,

---

what is DTS what are tasks available

1 Answers   Wipro,

---