Answer Posted / @panwar

yes but for same table and if you use foriegn key as a
primary key for same table then there will be no benifit of
master-detail concept for it relation.
and if you follow the Master_detail concept then you can't
use as primary key for another table.

What is use of except clause?

1142

---

What is the difference between a check constraint and a rule?

1351

---

How do I edit a procedure in sql server?

1000

---

What is primary key and example?

998

---

How many triggers you can have on a table?

1035

---

What do you understand by coalesce in sql server?

1128

---

What does truncate do?

995

---

How is sql used in sql server?

1058

---

How do you know if sql server is running on your local system?

1098

---

Can I work with several databases simultaneously? : sql server management studio

1031

---

What does ss stand for sexually?

1143

---

What is data source object?

1064

---

How to create a user to access a database in ms sql server using "create user" statements?

996

---

How can you ensure that the database and sql server based application perform well?

1126

---

What is database replication? What are the different types of replication you can set up in sql server?

1017

---