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

What is an active database?

1014

---

What is awe?

1013

---

why would you call update statistics? : Sql server database administration

1089

---

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

1017

---

What is merge replication?

1106

---

What the difference between UNION and UNIONALL?

1040

---

Is it possible to create trigger on views?

987

---

Do you know what are the restrictions that views have to follow?

1079

---

How to get all stored procedures in sql server?

1001

---

what is spatial nonclustered index

992

---

What is difference between joins and subqueries?

1120

---

What are the tool windows in sql server management studio? : sql server management studio

1079

---

What is normalization? Describe its different types.

1105

---

What is sql server management studio? : sql server management studio

1075

---

Can sql servers link to other servers like oracle?

843

---