Answer Posted / amit srivastava
create table stup(roll int,name varchar,marks int)
select * from stup
Alter table stup drop column marks
select * from stup
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is store procedure? When do you use?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Differentiate between a local and a global temporary table?
When we should use and scope of @@identity?
Do you know how to store and query spatial data?
How to transfer data from a cursor to variables with a "fetch" statement?
Explain cross join or cartesian product in sql?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What is the purpose of forms?
What is cursors?
What is the difference between a stored procedure and a user defined function?
Does a sql server 2005 select statement require a from?
How many databases instances are there in sql server 2000?
What do you mean by an execution plan? How would you view it?
What are the new data types are introduced in sql 2000?
