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
Difference between Logical Page and Physical Page in SSRS.
What is difference between rownum and rowid?
What are the transaction properties?
What are statistics?
What according to you is the difference between mysql and sql server performance?
how to define testing of network layers? : Sql server database administration
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Explain different types of collation sensitivity?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
Difference between report and query parameter. Why do we need different type of parameter?
Explain triggers in sql?
What are the database roles? : sql server security
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
Define left outer join?
What is the cartesian product of the table?
