Re: How do I rename a column in a table
From: DMITRIYEV ANDREY <op8qc_at_qcunix1.acc.qc.edu>
Date: 14 Nov 1998 22:58:24 GMT
Message-ID: <72l1ug$li2$2_at_news.cuny.edu>
Date: 14 Nov 1998 22:58:24 GMT
Message-ID: <72l1ug$li2$2_at_news.cuny.edu>
fredrikpwahlgren (fredrik.p.wahlgren_at_mailbox.swipnet.se) wrote:
: Evetually I foud the answer in the manual. If anyone else should have this
: problem, here's Oracles example:
: CREATE TABLE temporary (newname, col2, col3)
: AS SELECT oldname, col2, col3 FROM static
: DROP TABLE static
: RENAME temporary TO static
Don't you have to take care of your referential inegrity afterwards? As far as I know foreign keys and primary keys are dropped on such 'creation'
Andrey Dmitriev www.qc.edu/~op8qc AOL: NetComrade AIM: NetComradeReceived on Sat Nov 14 1998 - 23:58:24 CET