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

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

567


Difference between report and query parameter. Why do we need different type of parameter?

662


How to maintain a fill factor in existing indexes?

603


How to make a remote connection in a database?

603


What is instead of dml trigger?

695






What is for xml in sql server?

614


What does executeupdate return?

616


Explain the difference between control flow and data flow?

614


What is mean by dml?

640


What is 'Join' and explain its various types.

717


Tell me when is the update_statistics command used?

596


What are entities and relationships?

641


What are the different methods available under sqlcommand class to access the data?

780


Can we install sql server 2016 on windows 7?

768


What is the cartesian product of the table?

642