RE: Modify Primary Key
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <jkstill@xxxxxxxxx>, <manoj.gurnani@xxxxxxxxxxxxx>
- Date: Fri, 14 Oct 2005 10:53:22 -0400
I just didn't understand the question!
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: Friday, October 14, 2005 10:22 AM
To: manoj.gurnani@xxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Modify Primary Key
Hi,
What are different steps to be followed in modifying a
primary
key(PK1) to exclude last primary key column from a list of
primary key
columns.
assuming referential integrity constraints exists on primary
key in diff
tables.
give necesary sql syntax to perform the tasks .
All the syntax required is found right here:
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.
htm
FYI: It is generally assumed that the poster of a question will have
done a fair amount
of research prior to asking a question requesting such a comprehensive
answer.
I see that Norman took the trouble to answer this. These types of
questions often
go unanswered if it appears that the poster did not try to answer the
question on
his own before asking someone else to answer it.
BTW, this question is a perfect example of why surrogate keys should be
used.
The PK should never be modified.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
