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>

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1589

---

What is a collation?

1073

---

what is hash nonclustered index

945

---

What is the syntax for encrypting a column in SQL Server?

1101

---

What is used to replicate sessions between instances in coldfusion clusters?

1052

---

How to find out what is the default collation in a database?

1101

---

How to update muliple row in single query?

1036

---

After removing a table from database, what other related objects have to be dropped explicitly?

1024

---

What is Transparent Data Encryption?

986

---

How you can find out if an index is useful to the optimizer?

920

---

How to get the definition of a user defined function back?

1028

---

How to create function with parameter in sql server?

1086

---

What is built-in function?

978

---

Which Model uses the SET concept

978

---

How to get @@error and @@rowcount at the same time?

1014

---