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 to create an multi-statement table-valued function?
What are the export options of ssrs?
What is difference between cte and view?
Differentiate between mongodb vs. Sql server?
Are null values the same as that of zero or a blank space?
How to connect a database with sql express.?
What is identity?
What is the library index called?
Explain view in sql server?
How can you find out how many rows returned in a cursor?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
Can an entity have two primary keys?
What is the purpose of indexing?
What protocol does sql server use?
What do you mean by authentication modes in sql server?