Answer Posted / krishnakumar

table create time must constraint name is important..create
time not use constraint name don't delete don't delete
constraint column

alter table table_name drop constraint <constraint name>
table create time use this query
create table delete_table(emp_id int constraint del_pk
primary key,age int)

constraint name delere query
.............................

alter table delete_table drop constraint del_pk

How to create a new schema in a database?

1131

---

Explain the steps to create and execute a user-defined function in the sql server?

957

---

How to scale out a federation by Sql statement?

116

---

Explain what is lock escalation and what is its purpose?

923

---

What is difference between inner join and join?

1034

---

What security features are available for stored procedure?

1023

---

Do you know how to make remote connection in database?

952

---

Explain transaction server auto commit?

1027

---

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

143

---

What is difference between primary key and foreign key?

891

---

Do you know clustered and non-clustered index?

972

---

What are the steps you must follow to hide sql server instances?

967

---

How do clustered indexes store data?

1089

---

Explain differences between web edition and business edition?

119

---

What is the difference between a stored procedure and a user defined function?

1014

---