Re: Renaming a column

Ali Galewski wrote:

> How do you rename a column in a table?

In any version before 9i you don't.

You have two choices.

1. alias the column name in your select statement as in

SELECT badname GOODNAME
FROM sometable;

or

2. Recreate the table from scratch.

If you have 9i I understand it can be done but I've not yet received my CD or learned the syntax.

Daniel A. Morgan Received on Sat Jul 21 2001 - 16:51:22 CDT