Have a sybase table that occupies 40GB of size. 30GB of this space is occupied by one column which is defined as type "Text". As the table has 15million rows and each text field value is reserved 2KB of space, this seems right. The issue now is that there is only 5GB of space avaialble and this text field is not required.
Is there a way to drop / modify this filed type alone and save the 30GB of space given that there is only 5GB available? The table also have a couple of other indexes which about about 0.5 GB each. It has been suggested that we need another 40GB of space for any alter / modify operation on the original table that occupies 40GB. Is this true.