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.

hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq

0 Answers   IBM,

---

Is truncate autocommit?

0 Answers  

---

What is proper subset of candidate key?

0 Answers  

---

What is the difference between mysql and mysqli?

0 Answers   HCL,

---

What are a scheduled jobs?

0 Answers  

---

What is Trace flag?

1 Answers   Wipro,

---

What are constraints? Explain different types of constraints?

26 Answers   Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro,

---

Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

2 Answers  

---

What are the authentication modes in SQL Server?

4 Answers   IBM, iSmart,

---

What is bcp? When does it use?

0 Answers  

---

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 Answers  

---

Can store procedure call by user define function in SQL server?

10 Answers   HCL,

---