1. Backup Table
2. ALTER TABLE user DROP PRIMARY KEY CASCADE;
This will drop the constraint and delete all foreign key relationships
to userid.
3. ALTER TABLE user ADD CONSTRAINT username_pk PRIMARY KEY (username)
USING INDEX TABLESPACE USER_INDEX;
This will create a new primary key constraint on username IF the username
field is unique and does not contain nulls. The second line is optional.
Laura
-----Original Message-----
From: Nguyen, David M [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 07, 2002 2:34 PM
To: Multiple recipients of list ORACLE-L
Subject: Changing column format
I create a table to store user account information and set "userid" column
to be primary key. I now want to set "username" to be primary key instead
of "userid", how do I change it? There are couple hundreds of records in
table. Please advise.
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
