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
Do you know nested transaction?
What do you mean by SQL injection attack?
What is the function of inner join?
How can sql server instances be hidden?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What stored procedure can you use to display the current processes?
What is join and name different type of joins?
What is a join in sql?
What is it’s similarity with sql server?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What are the restrictions that views have to follow?
Tell me about normalization in DBMS.
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
what is normalization? : Sql server database administration
How to bind a view to the schema of the underlying tables?
