we can directly ALTER OR DROP the column AND THEN COMMIT ON IT SO THAT IT

How to delete an attribute from the emp table

Question Posted / swetha

Answer Posted / swetha

we can directly ALTER OR DROP the column AND THEN COMMIT ON
IT SO THAT IT GETS MODIFIED

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to make conditional sum in ssrs?

183

What is the chart in report?

165

What are the types of processing and explain each? : sql server analysis services, ssas

1205

Explain the steps to use transact-sql cursor?

1154

What is executereader?

1001

What is function of ROLLUP ?

1139

What are 3 ways to get a count of the number of records in a table?

1122

How to modify an existing stored procedure in ms sql server?

1137

How to find the second highest salary of an employee?

1221

What is application role in sql server database security? : sql server security

1119

How do I find query history in sql server?

987

What is difference between rownum and row_number?

1022

Explain sql server authentication modes?

1185

How to execute function in stored procedure sql server?

1229

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1178