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 different types of stored procedures?

1155

What is a view in sql?

1021

Does table partitioning improve performance?

1015

Give main differences between "Truncate" and "Delete".

1150

How much memory that we are using in Logshipping Concept?

1842

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1939

Explain “row_number()” in sql server with an example?

1053

Do you know exporting and importing utility?

1104

What is the maximum size of sql server database?

1058

What is a schema in ms sql server 2005?

1027

What is the most common type of join?

1038

How column data types are determined in a view?

1006

How can you list all the columns in a database?

970

Explain what is row_number function?

1081

Please explain go command in sql server?

1111