Interested to Buy Any Domain ? << Click Here >> for more details...
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
Can you explain full-text query in sql server?
How and why use sql server?
What is an identity column in insert statements?
What is the federation in sql azure?
Explain what is cte (common table expression)?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
How to defragment table indexes?
Define right outer join in sql server joins?
What is molap and its advantage? : sql server analysis services, ssas
Difference between Logical Page and Physical Page in SSRS.
What happens if null values are involved in string operations?
how to take backup bcp out for a column in table in sql server?
Do you know what is blocking?
What is the significance of master, tempdb and model databases?
What is tablesample?
