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 properties of the transaction?
Can foreign key be duplicate?
Can you explain the disadvantages/limitation of the cursor?
How to provide default values to function parameters?
Explain how many types of relationship?
What is sql server schema compare? How we can compare two database schemas?
How can you know if the row fetched from cursor is still valid in underlying table?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
What are the difference between “where” and “having” clause in sql server?
How do I uninstall sql server 2014?
What is difference between clustered and non clustered index?
What are the differences between stored procedure and view in sql server?
What is always encrypted?
How would you go about developing a ssrs report?
What is difference between foreign key and unique key?