What order is table in?

Question

In SQL Server Management Studio, when I open a table, what order is returned data in.. cannot clearly identify what SQL is using for index or sort default

---

RDE

Answer 1

Opening a table in SSMS by using the Open Table feature is the equivalent of performing a SELECT statement without an ORDER BY clause.  Without an ORDER BY clause, the order in which rows are returned is not guaranteed or predictable. The presence of indexes on the table does not affect this.  

Kind regards,
Gail

---

Gail Erickson [MS] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 2

Hi

When you select the data using without any orderby clause it will return the data using CLUSTERED INDEX.

---

Prakash Nandwana,Bangalore,India