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.

How to rebuild all indexes on a single table?

0 Answers  

---

How do you delete a trigger?

0 Answers  

---

What Is The Difference Between Primary Key & Super Key

3 Answers   Accenture,

---

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 Answers  

---

What is the language structure to add a record to a table?

0 Answers  

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

What will happen if a column containing char type data is changed to the nchar data type?

0 Answers  

---

what is database replicaion? : Sql server database administration

0 Answers  

---

why we use cursor?

4 Answers   CarrizalSoft Technologies, Melstar, TCS,

---

Can truncate be rolled back?

0 Answers  

---

What is temporary table in sql server? Why we use temp table?

0 Answers  

---

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

0 Answers  

---