Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Rename columns

Re: Rename columns

From: <celia9268_at_my-deja.com>
Date: Sun, 20 Jun 1999 15:04:09 GMT
Message-ID: <7kivt4$ipb$1@nnrp1.deja.com>


In article <uHDVWXdu#GA.196_at_cpmsnbbsa03>,   "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?
>
> Thanks in advance!
> Brian Peasland
> peasland_at_msn.com
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sun Jun 20 1999 - 10:04:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US