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
Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
How much does sql server 2016 cost?
What is the difference between implicit and explicit transaction?
What is SQL Azure Fabric?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
Do you know what are the ways available in sql server to execute sql statements?
Where are full-text indexes stored?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Explain hostprotectionattribute in sql server 2005?
What is a fan-out query in SQL Azure?
What do you mean by SQL injection attack?
What are the different types of sql server replication? : sql server replication
Do you know what is a linked server in sql server?
What is a primary key?
Tell me what is de-normalization and what are some of the examples of it?
How to convert numeric values to integers in ms sql server?