RE: Alter table.

Posted in 1994

From: Mario R.Canto — 22 Jul 1994 09:53:07 -0400 — source: Informix-list mailing list archive (1991-1998)

To add a column without extending your dbspace you can unload the table to a /tmp file get the dbschema of the table. drop the table. (Make a good 0 level backup before) create the modified table (with the new column) load the table from /tmp file to the original columns. Hope this help Mario Canto