Answer Posted / sonia

Using the DROP COMMAND-
See the eg below--

create table stup(roll int,name varchar,marks int)
insert into stup values(1,'A',10)
insert into stup values(2,'B',20)
select * from stup
Alter table stup drop column marks
select * from stup

How to download microsoft sql server 2005 express edition?

1047

---

What is SQL Azure Firewall?

136

---

Does sql server 2000 full-text search support clustering?

863

---

What is pivot and unpivot?

1013

---

What is database replication?

1140

---

What are information schema views?

986

---

What is query processing?

935

---

what is a self join? : Sql server database administration

1038

---

What are different types of database indexes?

1099

---

What is difference between commit and rollback when used in transactions?

959

---

How would you use user_constraints table in DB?

1008

---

How do I connect to sql server database?

1010

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1005

---

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

1092

---

Explain index in sql server?

1012

---