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)

Can a synonym name of a table be used instead of a table name in a select statement?

0 Answers  

---

Which command executes the contents of a specified file?

2 Answers   ABC, InfoMedia,

---

What is MSDE?

2 Answers  

---

How do I find the port number for sql server?

0 Answers  

---

What are constraints? Explain different types of constraints?

26 Answers   Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro,

---

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,

---

Tell me what is the order in which the sql query is executed?

0 Answers  

---

What are the properties of the transactions?

0 Answers  

---

What are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  

---

When do you use SQL Profiler?

3 Answers   Wipro,

---

Do you know what is fill factor and pad index?

0 Answers  

---

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

0 Answers  

---