Re: Alter table.

We had to unload the table to a file Delete all the rows or drop the table Alter the table or re-create the table reload the table specifying(?) the column names in the insert statement or edit the file with the sed command to add in the new blank fields. -------------------------------------------------------------------------------- Paul Watje SPAMIS Data Center paulw@spamis.jcdc.eta.gov Largest Informix Shop Voice: (800) 598-5008 in San Marcos, TX FAX: (512) 396-6600 On 20 Jul 1994, Shyam Davuburu wrote: > Hi, > Is there anyway i can add a new column to a table without the temporary table > being created? The problem i have is that i don't have enough dbspace left, but the table has millions of rows, how can i add a new column to the table without running out of dbspace? If anybody has any ideas please let me know. > > Thanks in advace > Shyam > > > > --- > -- ---------------------------------------------------------------------------- > Shyam Davuluru | (408) 492 7328 - Work > shyam@minerva.robadome.com | (408) 246 2046 - Home > | > > >