| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Rename columns
On Fri, 18 Jun 1999 16:57:40 -0500, "Brian Peasland"
<peasland_at_email.msn.com> wrote:
>I want to rename a column in a table. I know that I can copy the table to a
>temporary table and recreate the table with the column renamed. But how do I
>ensure that the table constraints stay. I would like to be able to rename
>the column in a table without dropping any constraints. Is this a problem?
>Does anyone have a solution?
My "solution" has always been to check to see what constraints exist, and then recreate them on the new table. Renaming columns has never been my favorite task.
Jonathan
 |
 |