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

What is row_number () and partition by in sql server?

523

What do you understand by a view? What does the with check option clause for a view do?

610

Explain the dbcc pintable command when would you use it?

510

What is the fillfactor concept in indexes?

536

Explain can you implement data mining in ssrs?

106

What is xml datatype?

663

What is SQL Azure Data sync?

105

What is self join in sql server joins?

562

Explain the difference between clustered and non-clustered index?

546

Does partitioning improve performance?

495

How can you tell if a database object is invalid?

619

how you can list all the tables in a database?

528

How to enter unicode character string literals in ms sql server?

580

What is subreport?

100

What are different type of Collation Sensitivity?

559