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

What is the advantage of sql server?

1028

---

How do I run sql server 2014?

980

---

How to change the password of a login name in ms sql server?

1009

---

Write down the syntax and an example for create, rename and delete index?

978

---

What is the difference between having clause and where clause in sql server?

1090

---

What are the advantages of user-defined functions over stored procedures in sql server?

1033

---

What is set nocount on?

934

---

Why the trigger fires multiple times in single login?

1202

---

What are the types of ssrs?

145

---

How to skip remaining statements in a loop block using continue statements?

991

---

What is data modeling and Reterminal integrity?

1951

---

What is filtered index?

1088

---

What is data source document?

1032

---

Please illustrate physical database architecture? : SQL Server Architecture

980

---

How to generate create view script on an existing view?

983

---