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.

How to return the top 5 rows from a select query in ms sql server?

1140

---

Explain view in sql server?

1055

---

What is the process of normalization?

1125

---

Tell me what do you understand by a view? What does the with check option clause for a view do?

1021

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1140

---

What is the use of RDBMS?

1005

---

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

982

---

Explain indexing and what are the advantages of it?

1028

---

How do we Backup SQL Azure Data?

108

---

Does full backup break log chain?

962

---

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1016

---

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1607

---

What is the maximum size of a row in sql server?

969

---

How can i Relate Tables in SSIS

1081

---

Explain the microsoft sql server delete command? : SQL Server Architecture

1084

---