yes we can drop, but column should not have any data. eg: ALTER TABLE <

can we drop column from a table

Question Posted / rbs

Answer Posted / rbs

yes we can drop, but column should not have any data.
eg: ALTER TABLE <TB NAME> DROP COLUMN Col-name.

Is This Answer Correct ?

3 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What do you mean by between and in? Is between inclusive of specified range values?

1092

What type of database is db2?

973

How to create backup table in db2?

1098

what is the sqlcode -501

13170

Mention the various locks that are available in db2.

1045

what is db2 restart?

2165

Can we update view in db2?

1007

What action db2 takes when a program aborts in the middle of a transaction?

1156

How do we specify index to include or not during bind process.

2132

What is image copy in db2?

1023

Why select is not preferred in embedded sql programs?

1307

What is an instance database?

1059

What is a db2 collection?

1053

Who uses db2?

1056

Describe major components of db2?

1097