How to delete an attribute from the emp table

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write query to return all rows sql?

623


What is the difference between sdf and mdf?

685


What are different types of views?

559


How to see the event list of an existing trigger using sys.trigger_events?

575


How to add the custom code in Report?

99






What are the security related catalog views? : sql server security

540


What is executereader?

561


What are parameterized reports?

160


What is unique key constraint?

640


Do you think BCNF is better than 2NF & 3NF? Why?

801


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

497


What are the requirements to use odbc connections in php scripts?

601


What is difference between Datepart() and Datename() in SqlServer?

730


Explain what is row_number function?

572


What is Dependency Injection and provide example?

627