Answer / 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

Answer / swetha

we can directly ALTER OR DROP the column AND THEN COMMIT ON
IT SO THAT IT GETS MODIFIED

Answer / amit srivastava

create table stup(roll int,name varchar,marks int)
select * from stup
Alter table stup drop column marks
select * from stup

Answer / ram murthy

we can delete an attribute through delete command.

What the different topologies in which replication can be configured?

0 Answers  

---

What are the basic functions for master, msdb, model, tempdb databases?

0 Answers  

---

Is port 1433 secure?

0 Answers  

---

Is index a datbase objects in sql server?

2 Answers  

---

List out the different types of locks available in sql server?

0 Answers  

---

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com

28 Answers   IBM, Symphony,

---

what is IDE,DMV in sql server?

1 Answers   Value Labs,

---

How can we call UDF(User Define Function) using C# code in ASP.net ?

1 Answers  

---

What is difference statement and preparedstatement?

0 Answers  

---

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

0 Answers  

---

What languages bi uses to achieve the goal?

0 Answers  

---

How do we know if any query is retrieving a large amount of data or very little data?

0 Answers  

---