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 is difference between clustered and non clustered index?

0 Answers  

---

what is the system function to get the current user's user id? : Sql server database administration

0 Answers  

---

What is difference between join and natural join?

0 Answers  

---

what is the main difference between after trigger and instead trigger.

2 Answers  

---

How to trouble shoot if unable to connect SQL Server

0 Answers  

---

---

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

0 Answers  

---

Plz tell about backup&recovery?

3 Answers  

---

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

1 Answers  

---

What is tempdb in sql server?

0 Answers  

---

If we use where clause in the left outer join then how the query would behave/act?

1 Answers  

---

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

0 Answers  

---

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

0 Answers  

---