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 difference between data mart and data warehouse? : sql server analysis services, ssas

933

---

What is the use of =,==,=== operators?

990

---

What are the steps to follow to configure SQL*Net?

1018

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

939

---

What is side by side migration in sql server?

1078

---

Name few endpoints exposed by ssrs 2012?

355

---

Explain cdc and sql injection?

957

---

What is the purpose of the tempdb database?

984

---

What is constraints and its types?

924

---

Do you know what is rank function?

1064

---

What is sql server schema compare? How we can compare two database schemas?

1007

---

Can you please explain the difference between primary keys and foreign keys?

1092

---

Can we create clustered index on composite key?

1052

---

What is a heap?

1021

---

What is efficiency data?

940

---