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>

Describe and explain about SQL native client?

1099

---

What is the purpose of the master database?

1115

---

what is the difference between count(*) and count(1) ?

1076

---

When would you use the stored procedures or functions?

998

---

Define clusters?

1052

---

Explain different types of collation sensitivity?

973

---

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1027

---

How would you add a section to a table?

1025

---

How can sql injection be stopped? : sql server security

1027

---

How can you ensure that the database and sql server based application perform well?

1065

---

Differentiate between a local and a global temporary table?

946

---

Explain the different types of backups available in sql server? : sql server database administration

915

---

What are the diifferences between the ms sql server vs mysql?

1164

---

Explain what are page splits? : SQL Server Architecture

1054

---

What is the security principal at the database level that represents your session?

929

---