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 are the differences between decimal and float in ms sql server?

1344

---

How to provide default values to function parameters?

1219

---

What is an example of a primary key?

1037

---

What is a partition function in sql server?

1215

---

In which format does an image save in SQL Server database ?

1054

---

Is mysql the same as sql server?

1031

---

What is the distinction amongst delete and truncate?

1110

---

What is the purpose of sql profiler in sql server?

1066

---

What specific conditions database should meet, before you can bulk copy data into it using bcp?

1039

---

What is the recovery model? List the types of recovery model available in sql server?

944

---

How to create an index on a view?

1138

---

What is the datatype of rowid?

963

---

Explain aggregate functions?

1138

---

Explain what is raid and what are different types of raid levels?

1087

---

What is a join in sql?

1152

---