Re: How to change column names?
From: Matthias Wipf <wipf_at_fzi.de>
Date: 1998/09/22
Message-ID: <3607B7A2.7BD2_at_fzi.de>#1/1
Date: 1998/09/22
Message-ID: <3607B7A2.7BD2_at_fzi.de>#1/1
You can't do it directly.
But try this:
CREATE TABLE temp (newname, col, col3, ...)
AS SELECT oldname, col2, col3, ... FROM mytab;
DROP TABLE mytab;
RENAME temp TO mytab;
--Received on Tue Sep 22 1998 - 00:00:00 CEST