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 are the commands used in DCL?
When would you use it?
What are the differences between stored procedure and view in sql server?
Why I have to use stored procedures?
What is the most common trace flags used with sql server?
List out the difference between union and union all in sql server?
What command is used to rename the database?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
Mention the different types of triggers?
What are the advantages of user defined function?
How does clustered and non clustered index work?
Can a table have 2 primary keys?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
Define Business Edition in SQL Azure?
What is pessimistic concurrency?
