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

List some major differences between triggers and stored procedures?

894

Tell me what is the significance of null value and why should we avoid permitting null values?

967

Where the sql logs gets stored? : sql server database administration

945

Define self join in sql server joins?

935

Explain Reporting Life Cycle?

125

What is the difference between truncate and delete commands?

1047

What are triggers in ms sql server?

1144

What is the main difference between ‘between’ and ‘in’ condition operators?

1167

What is serializable?

1027

What is transaction server explicit transaction?

1013

Which tools are available to manage SQL Azure databases and servers?

115

What is dimension table? : sql server analysis services, ssas

1001

What are functions in the sql server?

1188

What is the stuff?

985

What is the name of the system variable that returns the number of rows affected by a SQL statement?

992