can we drop column from a table

Answer Posted / srini

We can not drop a column. If we want we can append colume
with ALTER command.

Is This Answer Correct ?    30 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can deadlocks be resolved?

544


What do you mean by cursor?

586


Mention the various locks that are available in db2.

618


Explain how can you do the explain of a dynamic sql statement?

654


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

630






Is ibm db2 free?

577


What is collection in db2 bind?

579


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2324


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

585


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2284


What is a dbrm in db2?

580


What is the difference between drop table and delete table?

556


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2048


What is innodb buffer pool?

564


Which command is used to remove all rows from a table?

553