Answer Posted / devendra sharma

Yes it is possible that a primary key can be non clustered

create table abc(eid int PRIMARY KEY
NONCLUSTERED,ename varchar(50),vid int)

create clustered index abc_clustered on abc (vid)


now if you will check the index on eid cloumne it will be
unique and vid will have a clustered index.

Give it a try if you don't belive......

What is difference between commit and rollback when used in transactions?

966

---

What does sql server mean?

1077

---

Explain full-text indexing?

993

---

How much does sql server 2016 cost?

1079

---

application server is slow what may be the problem

2228

---

Why is normalisation important?

951

---

Explain what are the restrictions while creating batches in sql server?

1079

---

What are the differences between user defined functions and stored procedures?

1078

---

Sql server reporting services vs. Crystal reports.

134

---

What is the xml datatype?

1086

---

How to insert data with null values?

1039

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

1097

---

What is plan freezing?

977

---

How to create a new schema in a database?

1154

---

How to insert data into an existing table?

984

---