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

What do you mean by an execution plan? How would you view it?

706


What is an execution plan? How would you view the execution plan?

828


What is cursors?

822


Explain syntax for viewing, dropping and disabling triggers?

706


Can you explain the disadvantages/limitation of the cursor?

683


What is the difference between local and global temporary tables?

802


How many types of built in functions are there in sql server 2012?

691


What is the report model project?

122


Scalability, Availability, Integration with internet, etc.)?

2616


Can a table have 2 primary keys?

736


How to check table values in sql server?

704


How to retrieve error messages using odbc_errormsg()?

742


How to generate create function script on an existing function?

798


What is the difference between a primary key and a unique key? Are they the same?

790


How ssrs maintain security?

795