Re: RENAME COLUMN

From: Jeremy Russell <jeremy.russell_at_usa.net>
Date: Fri, 23 Feb 2001 02:01:05 GMT
Message-ID: <3a95c3e1.124215392@news.earthlink.net>

Further to previous answers, you can rename the original table and then create a view named as the original table with an select statement including an alias for the column to rename.

For example:

RENAME table1 to hidden_table;
CREATE VIEW table1 AS
SELECT column1, column2 AS NEWCOL
FROM hidden_table;

On Thu, 22 Feb 2001 15:23:53 +0100, "Pascal Giansily" <pascal_at_studio.vinternet.net> wrote:

>How can i rename column name?????
>Thanks...
>
>
Received on Thu Feb 22 2001 - 20:01:05 CST