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
What are dml triggers and types of dml triggers?
SQL Server Architecture ?
Explain triggers?
What’s the distinction between dropping a info and taking a info offline?
What is data modeling and Reterminal integrity?
How many types of stored procedures are there in sql server?
What is named calculation? : sql server analysis services, ssas
Explain the truncate command?
How will you monitor replication latency in transactional replication? : sql server replication
Can you explain various data region available in ssrs with their use?
How to change the system date and time from SQL Plus Terminal ?
What are the mathematical functions supported by sql server 2005?
can any body tell me how to know the password of current user in sql server
How to join two tables in a single query in ms sql server?
Explain intellisense for query editing
