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
What is the use of =,==,=== operators?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What are the recovery models for a database?
Is it possible to replicate data from sql server to oracle? : sql server replication
What is the difference between executequery () and executeupdate ()?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
can you implement data mining in SSRS?
Can group functions be used in the order by clause in ms sql server?
How do I setup a local sql server database?
What is an execution plan? When would you use it?
What is the difference between update lock and exclusive lock?
What does truncate do?
Mention the different types of replication in sql server.
How to defragment indexes with alter index ... Reorganize?
What happens if you add a new index to large table?