Sven Koehler wrote: > > --> in your table the columns seem to be marked as 'dropped', > > but the space is not released because > > you did not specify RELEASE SPACE. > > is it possible to release the space when the column is already dropped?
It is not possible directly. If you will do something like this: ALTER TABLE mytab mycol int and then ALTER TABLE mytab DROP mycol RELEASE SPACE not only the space of mycol, but the space of all columns marked as 'dropped' will be released from mytab. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
