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 are sp_configure commands and set commands?

0 Answers  

---

How to run queries with sql server management studio express?

0 Answers  

---

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,

---

How to convert numeric values to integers in ms sql server?

0 Answers  

---

How fixed length strings are truncated and padded?

0 Answers  

---

What is trace flag in sql server?

0 Answers  

---

how to insert the values in 5 table at a time Using any single statement ?

6 Answers   Infosys, Value Labs,

---

What are the different authentication modes in sql server? How can it be changed?

0 Answers  

---

How to Run a Query on a Remote SQL Server?

2 Answers  

---

How do we get current date in SQL Server 2000, Oracle, MS Access?

13 Answers  

---

What causes index fragmentation?

0 Answers  

---

What is 2nf example?

0 Answers  

---