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>

What is @@rowcount in sql?

1006

---

What are points to remember while using the fillfactor argument?

970

---

What is correlated subquery in sql server?

1073

---

What is replication with database mirroring? : sql server database administration

1079

---

Give me any three differences between Truncate and Delete.

1107

---

How can you set the threshold at which sql server will generate keysets asynchronously?

990

---

How to start and end transact-sql statements?

1030

---

What happens when the SQL Azure database reaches Max Size?

111

---

How can I check that whether automatic statistic update is enabled or not?

1042

---

Explain what is scheduled job and how to create it?

958

---

How to delete an existing row with delete statements in ms sql server?

1093

---

How many clustered indexes there can be on table ?

1039

---

what changed between the previous version of sql server and the current version? : Sql server database administration

1014

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1140

---

Explain contrast amongst grouped and non-bunched records?

1021

---