Re: Deleting columns from an Illustra table?

Posted in 1997

Seth Grimes — 29 May 1997 21:42:21 -0400 — source: Informix-list mailing list archive (1991-1998)

"Michael Ossege" <mossege@iname.com> writes: >How do I delete colums from an Illustra Server table? >Alter Table just allows it to add or rename. Create another table, copy data to it minus the deleted column, drop the first table, and then rename the second back to the first. That is, there's not elegant way. Seth -- Seth Grimes -- grimes@access.digex.net -- http://www.access.digex.net/~grimes grimes@magnet.com -- http://www.magnet.com