Re: Renaming a primary key

From: Marc Blum <marc_at_marcblum.de>
Date: Sun, 13 Oct 2002 15:19:57 +0200
Message-ID: <bnsiqu8q1eecq15lgd28gnvl9jhdpgopu0@4ax.com>

On Fri, 11 Oct 2002 09:09:45 -0400, P B <pbeliveau_at_avcorp.com> wrote:

>I have a set of table that look like this:
>
>One table with a P/N as a primary key and within some reference to
>other P/N
>
>One table with a P/N and a SPEC as a primary key (P/N referencing to
>the other table of course)
>
>And finally a bunch of other table referencing to the second table
>(P/N & SPEC)
>
>Question: How do I proceed to rename the primary key of the first
>table and cascade the change to all other table ?
>
>Thanks

SQL> SELECT banner
  2 FROM v$version;

BANNER

---

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production

SQL>
SQL> DROP TABLE t;

Tabelle wurde gelöscht.

SQL>
SQL> CREATE TABLE t
  2 (v VARCHAR2(1));

Tabelle wurde angelegt.

SQL>
SQL> ALTER TABLE t
  2 ADD CONSTRAINT pk
  3 PRIMARY KEY (v);

Tabelle wurde geändert.

SQL>
SQL> SELECT constraint_name
  2 FROM user_constraints
  3 WHERE table_name = 'T';

CONSTRAINT_NAME

---

PK

SQL>
SQL> ALTER TABLE t
  2 RENAME CONSTRAINT pk TO pk_2;

Tabelle wurde geändert.

SQL>
SQL> SELECT constraint_name
  2 FROM user_constraints
  3 WHERE table_name = 'T';

CONSTRAINT_NAME

---

PK_2

SQL>
SQL> Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de Received on Sun Oct 13 2002 - 08:19:57 CDT