can we drop column from a table

Answer Posted / kumar

It is not possible directly. Indirectly we could do it.
Create a view by eliminating the column (th one to be
deleted). Drop the table or create a new table. Copy from
the view to the newly created table. Pl correct if I'm
wrong.

Is This Answer Correct ?    7 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is phantom read in db2?

644


What db2 400?

680


What is null in db2?

575


What are the uses of db2 optimizer?

819


What is db2? Explain.

606






How many databases can be created inside an instance in db2 ?

605


What is db2 optimizer?

771


How to find the number of rows in a db2 table?

644


Explain what are the various isolation levels possible?

610


What does sqlcabc has?

633


What is a page in db2?

612


What is check constraint in db2?

611


What is consistency token in db2?

644


Why do we need reorg in db2?

566


What is the physical storage length of the data types date, time, and timestamp?

612