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 the command to change the recovery model?

999

---

Tell me what is log shipping?

935

---

Tell me what are cursors and when they are useful?

909

---

Why is replication required on the sql server?

1007

---

Can sql servers linked to other servers like oracle?

901

---

What is the current pricing model of SQL Azure?

104

---

What to perform pattern match with the like operator?

837

---

Explain the steps needed to create a scheduled job?

883

---

How to rename an existing column with sql server management studio?

948

---

What to check if a User database is locked?

1018

---

How can you check the level of fragmentation on a table?

986

---

whats the maximum size of view state??

2146

---

What happens if date-only values are provided as date and time literals?

975

---

Do you know what are the properties of the relational tables?

981

---

How to create an inline table-valued function?

907

---