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

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

Please Help Members By Posting Answers For Below Questions

What are the system database in sql server 2005?

1046

What is autocommit mode in sql server?

1179

How do you trace the traffic hitting a sql server?

1142

Define outer join?

1003

How to insert multiple rows with one insert statement in ms sql server?

1127

Explain about extended stored procedure?

941

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

995

What do you understand by the denormalisation?

960

What is an execution plan?

1153

Why use update_statistics command in sql server?

1058

Does index speed up select statements?

1013

What is the difference between left and right outer join?

1063

What are security principals used in sql server 2005?

988

How to stop a loop early with break statements in ms sql server?

1020

What are the key configuration files for sql server reporting services ?

167