why can't we delete a coloum from a table?

achusarath · New User Joined: 21 Mar 2007 Posts: 26 Location: kerala

hi gurus,

please tell why can't we delete a coloum from a table

wanderer · Posted: Thu Apr 19, 2007 10:16 am

Because IBM says so and nobody can do anything about it.

mkk157 · Active User Joined: 17 May 2006 Posts: 310

Hi achusarath,

We can delete the rows of a table by using a DELETE statement. If you go on deleting the rows, at one instance there may be a situation that a table contains zero rows. This is possible because A Table can exists without any rows.

But at the same time, There is no meaning of table without any columns, for this reason IBM did not give this option.

Correc me If I am wrong....