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 are some examples of schemas?

0 Answers  

---

What’s the distinction between dropping a info and taking a info offline?

0 Answers  

---

What is Inner Join?

2 Answers  

---

Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

internal language used in sql server 2000?

2 Answers  

---

How to execute stored procedure and set temp table in sql server?

0 Answers  

---

Explain different types of locks in sql server.

0 Answers  

---

How do I open port 1433?

0 Answers  

---

What are the differences between substr and charindex in sql server.

0 Answers  

---

What is the Difference Between Primary and Foreign Key?

0 Answers   Accenture, Deloitte, JPMorgan Chase, Maveric,

---

Explain time data type in sal server 2008?

0 Answers  

---