create table stup(roll int,name varchar,marks int) select * from stup Alt

How to delete an attribute from the emp table

Question Posted / amit srivastava

4 Answers
9524 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What is SQL Azure?

105

What is acid db?

877

What is a derived table?

921

When should you use an instead of trigger?

949

What is the sql server 2000 version number?

1072

How to add more data to the testing table in ms sql server?

1076

Differentiate between a having clause and a where clause.

961

How to create a view using data from another view?

946

What is the difference between Clustered and Non-Clustered Index?

1051

How to send a ssrs report from ssis?

175

What are types of storage modes? : sql server analysis services, ssas

1024

What is page in sql server?

941

What is server-level principal?

122

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

945

How do you delete a trigger?

965