Re: How to change column names?

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 - 09:43:46 CDT