Answer Posted / pooja khanna

As i understand this question is not about removing the
constraint in a column. It is about removing the columns
containing default constraint.
If it is about removing the default constraint then given
answer no. 1 is absolutely correct.It's quite a bit similar.
However, if you want to remove column containing default
constraint,first you need to drop the default constraint
then you can remove the column/'s :-

First remove the constraint :
eg :- as answer 1.
step 1:- alter table <table-name> drop constraint
<constraint-name>

step 2: alter table <table-name>
drop column <column-name>

Do you know what is a trace frag? Where do we use it?

955

---

What is index, cluster index and nonclustered index?

927

---

Which language is supported by sql server?

954

---

Difference between aggregate functions of sql?

1039

---

How do I find the default sql server instance?

902

---

What are the advantages of partitioning?

1045

---

Explain the dbcc pintable command when would you use it?

867

---

What are the kinds of subquery?

951

---

What happens if null values are involved in datetime operations?

903

---

How do I get to sql server configuration manager?

951

---

What is the difference between truncate and delete commands?

1002

---

Which are the new data types introduced in sql server 2008?

842

---

What are the different types of lock modes in sql server 2000?

882

---

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

925

---

What is default port number for sql server 2000?

993

---