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
New concepts of sql server 2005 use in your project.
What stored by the model? : sql server database administration
What is the difference between Normalization and De-normalization?
What is 2nf example?
Tell me about joins in database system and explain each in detail.
How would you choose between a clustered and a non-clustered index?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What is the difference between a clustered index and a non-clustered index?
Explain transaction server consistency?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
Why can there be only one clustered index and not more than one?
How to execute a sql statement using mssql_query()?
What are “phantom rows”?
In which files does sql server actually store data?
Define inner join in sql server joins?
